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, column2, column3) SELECT old_table.column1,old_table1.column2,old_table2.column3 FROM old_table,old_table1,old_table2
For this command you can use join query as well.

Chandra Shekhar

Latest posts by Chandra Shekhar (see all)
- Mobile App development with Vue Native - February 24, 2022
- Best practices for micro service design - January 23, 2022
- Spring Boot - January 23, 2022
Recent Comments