insert data from one table to another in mysql


New Table structure

id email_id date status
1 xyz@hotmail.com 2013-09-04 10:59:17 1
2 abc@gmail.com 2013-09-04 10:59:17 1
3 test@gmail.com 2013-09-04 10:59:17 1

insert data from one Table to another Table Query

Query :

Insert into newtable(email_id) Select ’email_id’ from oldtable.

Leave a comment