SQL问题初学者

显示全部楼层 · 2009-7-31 13:45:17

UPDATE H_CARDSET hjgwID = '6666'WHERE hjgwID in ('0002','0003','0004') 但是,你这表里的HJGWID是不是主键?如果是主键的话不可能三个都是一个值...

千问 · 2009-7-31 13:45:17

yybb009你那错误的sql也想拿分啊! 你那条语句永远update不到记录应该是这样写的UPDATE H_CARDSET hjgwID = '6666'WHERE hjgwID = '0002'or hjgwID = '0003'or hjgwID = '0004'...

千问 · 2009-7-31 13:45:17

UPDATE H_CARDSET hjgwID = '6666'WHERE hjgwID = '0002'and hjgwID = '0003'and hjgwID = '0004'下次记得给分，素质！...

千问 · 2009-7-31 13:45:17

UPDATE H_CARDSET hjgwID = '6666'WHERE hjgwID in ('0002','0003','0004')...

千问 · 2009-7-31 13:45:17

2楼正确...