Question

SQL：一张表里，一次执行两条更新的语句，怎么写？

1."UPDATE ies_messagelayout SET msgisused = 1 WHERE msglaotid=2";
2."UPDATE ies_messagelayout SET msgisused = 0 WHERE msgtpid={$msgtp}
第一条SQL语句是msglaotid=2的记录里msgisused = 1，执行完了以后我再直接执行第二条SQL语句，把剩下的记录里msgisused再更新为0

Answer 1

可以的，两条语句之间加个分号隔开就好了

Answer 2

UPDATE ies_messagelayout SET msgisused = 0 WHERE msgtpid<>1

Answer 3

Update messagelayout set msgisused = case when msglaotid=2 then 1 when msgtpid={$msgtp} then 0 end

Answer 4

用事务吧~