Insert into select Mysql query example

We often looking for mysql query to copy data from one table to another table.To handle such kind of scenario using mysql query mysql we can use below mysql command. INSERT INTO new_table (column1, column2, column3) SELECT old_table.column1,old_table.column2,old_table.column3 FROM old_table Mysql Query to copy data from multiple tables to one table INSERT INTO new_table (column1,(…)