报错:1093 You can’t specify target table ‘titles_test’ for update in FROM clause"
报错语句
DELETE from titles_test where id not in (
SELECT min(id) from titles_test group by emp_no )
解决方法,在子查询中再套一层查询
DELETE from titles_test where id not in (
select * from(
SELECT min(id) from titles_test group by emp_no ) t1
)
报错:**1142** SELECT command denied to user .....
检查是否是没有相关的权限 :查询、修改、插入、删除