Question

0 0

postgresql中 update语句可以用limit 吗？


 sql


 update a set b =1  limit 1//报错，去掉limit 1 就没事

10 years, 8 months ago

share

hwbest 10 years, 8 months ago

Answer 1

0

如果只是改一条数据，最好指定ID
update table set column=value where id = ?

如果没有ID就用where指定其他条件

answered 10 years, 8 months ago

share

VFIVE answered 10 years, 8 months ago

Answer 2

0

看了一下手册，update 命令里没提到 limit，所以应该是不可以的。

其实想想也挺正常的——你 update 和 limit 放一起是要干什么呢？

answered 10 years, 8 months ago

share

十六夜吃宵夜 answered 10 years, 8 months ago