mysql 错误代码: 1093

最新推荐文章于 2024-01-08 10:16:59 发布

一叶飘零_sweeeet

最新推荐文章于 2024-01-08 10:16:59 发布

阅读量1k

点赞数

文章标签： mysql

本文链接：https://blog.csdn.net/jam_yin/article/details/82964640

版权

mysql 更新报错：

UPDATE app_member mm SET mm.stat =0 WHERE mm.id IN(SELECT m.`id` FROM app_member m WHERE m.phone_number IN ('13212708617','13277955778','13545908940','13554246007','13907100681','13995559595','15307156768','15392882670','15927532264','18062519830','18064046799','18071721057','18502714816','18627881817','18986123455','18995517506') AND m.`member_type` =1);

正确写法：

UPDATE app_member mm SET mm.stat =0 WHERE mm.id IN(SELECT id FROM (SELECT m.`id` FROM app_member m WHERE m.phone_number IN ('13212708617','13277955778','13545908940','13554246007','13907100681','13995559595','15307156768','15392882670','15927532264','18062519830','18064046799','18071721057','18502714816','18627881817','18986123455','18995517506') AND m.`member_type` =1) AS temtable);