How to Copy Data from one Column to another Column of Table: MySQL

You might have a table with some information and you want to copy the data of a few columns to another table. First thing you need to do is to create a table with columns same to the specific columns you require from original table.

Let say you have a table table1 with following fields:

name, email, company

You want to copy all the names and emails to a new table. So you will create a new table let say table2 with fields:

name, email

Following query will copy all the names and emails from table1 to table2

INSERT INTO`table2`(name, email)
SELECT name, email
FROM `table1`

You can also copy filtered records using where clause like

INSERT INTO `table2`(name, email )
SELECT name, email
FROM` table1`
WHERE company='Google'