What is the difference between using SELECT INTO and INSERT INTO? Both can be used to copy data from one table into another
selectinto
Copy data into new table in MySQL
You can easily copy data into new table in MySQL using SELECT INTO. This helps you create temporary tables quickly.