13.2.5.1 INSERT ... SELECT Syntax - MySQL

The target table of the INSERT statement may appear in the FROM clause of the SELECT part of the query. (This was not possible in some older versions of ...

dev.mysql.com