selectmysql
mysql 版本 5.7.9
原来的代码进行的操作
update message_list set status = 1 where recid in (select recid from message_list );
根据网上 添加一个中间表后 还是不能进行update 操作
pdate message_list set status = 1 where recid in (select a.recid from (select c.* from message_list c) a);
下面是错误信息
mysql> update message_list set status = 1 where recid in (select a.recid from (select c.* from message_list c) a);
1093 - you can't specify target table 'message_list' for update in from clause
mysql>