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.