如何在MySQL中更新多个值?
这不起作用:
UPDATE test SET list=0,
price= 0.00 cprice= 0.00 WHERE test.id =3232
发布于 2009-11-03 00:11:50
您需要在两个不同的值之间放一个逗号,例如:
UPDATE orders
SET listPrice = 0,
bloggerPrice = 0.00,
customerPrice = 0.00
WHERE orders.id =245745
发布于 2009-11-03 00:10:44
您缺少一个逗号:
UPDATE orders SET
listPrice = 0,
bloggerPrice = 0.00,
customerPrice = 0.00
WHERE
orders.id = 245745
发布于 2009-11-03 00:10:51
尝试:
UPDATE orders
SET listprice=0, bloggerPrice=0.00, customerPrice=0.00
WHERE id=245745
https://stackoverflow.com/questions/1662180
复制相似问题