raw sql

delete from at_phone where id not in(select id from at_phone where id!=1)

Run this sql statement, the result is an error

[Err] 1093 - You cannot specify target table 'at_phone' in FROM clause for update

Cause solution: If you want to add, delete, and modify in the form of a subquery in the addition, deletion and modification statement, you should select the subquery a second time and give the above table an alias before it can be executed.This second select actually puts the result set of the first select in a temporary table.

The resolved sql:

delete from at_phone where id not in(select * from (select id from at_phone where id!=1) a)

executed successfully

Summary

If you think it's good, you can like + bookmark or follow the blogger.Thanks for reading!