How to Copy one table data to another table using MySQL Query

In this blog you will learn how to copy one table data to another table in MySQL, sometimes there is a need to copy data from one table to another, if we do this manually it will take a lot of time so in this, you will learn how we can do this by the query. Let’s see the following:

Write this code in your PHPMyAdmin SQL or on MySQL:

INSERT INTO table2  SELECT * FROM table1

Example:

INSERT INTO pages  SELECT * FROM staticpages 

Categories: web development mysql