有两张表 一个表名是sms_red 一个表是ter 里面有共同的 no
ter表中有个状态码 sms_state;
若状态码为N 则把 sam_red里面的no更新到ter中的no 否则不更新。
update ter set ter.no =
(select red.no from ter ter join sms_red red on red.id = ter.id where ter.sms_state = 'N')
where ter.sms_state = 'N' and ter.id in (select ter.id from ter ter join sms_red red on red.id = ter.id where ter.sms_state = 'N')
ter表中有个状态码 sms_state;
若状态码为N 则把 sam_red里面的no更新到ter中的no 否则不更新。
update ter set ter.no =
(select red.no from ter ter join sms_red red on red.id = ter.id where ter.sms_state = 'N')
where ter.sms_state = 'N' and ter.id in (select ter.id from ter ter join sms_red red on red.id = ter.id where ter.sms_state = 'N')