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

Trending Courses

CodeIgniter

Regular : 45 Days

Fastrack : 20 Days

Crash : 10 Days

Advance Digital Marketing

Regular : 6 Months

Fastrack : 3 Months

Crash : 2 Months

React JS

Regular : 45 Days

Fastrack : 20 Days

Crash : 7 Days

Laravel

Regular : 45 Days

Fastrack : 20 Days

Crash : 10 Days

Front End Developer

Regular : 7 Month

Fastrack : 4 Month

Crash : 2 Month

Request For Demo