随笔分类 -  开发/ Development

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 测试眼 阅读(384) 评论(0) 推荐(0)