Mysql learning practices --- select into alternative solution, mysql --- select

Mysql learning practices --- select into alternative solution, mysql --- select

Copy data from one table and insert the data into another new table.

Assume that there is an orders table that has been created and has data. Back up the orders table to the newOrders table that has not been created.

SQL usage: SELECT * INTO newOrders FROM orders

However, when mysql is used, ERROR 1327 (42000): Undeclared variable: newOrders reports an ERROR even if the newOrders table structure is created manually. Therefore, mysql does not support select.

Therefore, an alternative solution can be used: create table newOrders (SELECT * FROM orders );