Question

mysql 语句 where not in

UPDATE cdxh_product SET stockNums = '0' WHERE productcode NOT IN [CDXHP1591,CDXHP1305,CDXHP1306,CDXHP2237];
请问哪里错了

Answer 1

1. 用括号

2. 用单引号

3. 去掉='0' 的单引号
UPDATE cdxh_product SET stockNums = 0 WHERE productcode NOT IN
('CDXHP1591','CDXHP1305','CDXHP1306','CDXHP2237');