update message_process2 mp
INNER JOIN ( select ICPN from message_process2 mp where failture like '%Connection refused%' and status = 100
UNION
select ICPN from message_process2 mp where failture like '%Read timed out%' and status = 100 ) mp2
set status = 1
where mp.ICPN=mp2.ICPN and status = 100
如果是查询更新同一张表,MySql是不允许的,所以这里用INNER JOIN 引入内部关联表即可完后查询更新
MySQL查询并更新
最新推荐文章于 2024-06-20 09:23:39 发布