UPDATE tableName SET name='abc' WHERE id IN ('001,002,003')这样写不对的!---------------------------------如果ID是数字,应该是这么写:
UPDATE tableName SET name='abc' WHERE id IN (001,002,003)-------------------------------------------------------------
如果ID是字符串,应该是这么写:
UPDATE tableName SET name='abc' WHERE id IN ('001','002','003')
UPDATE tableName SET name='abc' WHERE id IN (001,002,003)-------------------------------------------------------------
如果ID是字符串,应该是这么写:
UPDATE tableName SET name='abc' WHERE id IN ('001','002','003')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货