How to Insert Data from One Table to Another in MySQL

MySQL INSERT … SELECT statement provides an easy way to insert rows into a table from another table. If you want to copy data from one table to another in the same database, use INSERT INTO SELECT statement in MySQL. It’s a very quick process to copy large amount data from a table and insert into the another table in same MySQL database.

In the example of INSERT ... SELECT syntax, we’ll copy data from posts table and insert into the posts_new table. You can also specify a predefined value in the SELECT statement.

Use the following SQL query to insert data from one table to another in MySQL.

INSERT INTO posts_new (user_id, title, content, status) 
SELECT published_by, title, content, '1' 
FROM posts ORDER BY id ASC