13.2.5.1 INSERT ... SELECT Syntax - MySQL

To avoid ambiguous column reference problems when the SELECT and the INSERT refer to the same table, provide a unique alias for each table used in the  ...

dev.mysql.com