MySQL uses query results to generate temporary tables

MySQL does not support using its query results on the same table to update or delete data in this table (that is, update or delete after the where condition is for the same table Select), the solution is to create a temporary table to do over-save intermediate data;

You can use query results directly to form temporary tables

SQL code

1. CREATE TABLE tmp as
2. (SELECT column1 as field1, Column2 as field2 ...);

The resulting table name is TMP
The query results for the column columns in the table, which can be renamed according to the name of the