You can't specify target table 'user_student' for update in FROM clause

mysql删除id最小的一条

错误语句

执行以下语句报错

delete from user_student where id = (select min(id) id from user_student) 

You can't specify target table 'user_student' for update in FROM clause

不能先select出同一表中的某些值，再update这个表

是因为不允许在同一个表中先查询再更新

正确语句

delete from user_student where id = (select id from(select min(id) id from user_student) t1)

方法二

delete from user_student order by id asc limit 1;