Mysql更新数据时,报 “You can't specify target table 'message ' for update in FROM clause” 解决办法
摘要:报错的SQL为: delete from message where id not in (select min(id) as id from message group by content); 报错信息的中文意思为:不能在FROM子句中更新 message表数据,原因是 "不能在从本表中查出数据
阅读全文
posted @ 2019-08-27 16:37
浙公网安备 33010602011771号