How To Copy Data From Table To Table Using MySQL
erics, June 8th, 2011 |
1 2 |
CREATE TABLE newTable LIKE oldTable; INSERT INTO newTable SELECT * FROM oldTable; |
|
1 |
INSERT INTO newtable (`name`, `address1`, `address2`, `city`, `state`, `zip`, `phone`) SELECT `name`, `address1`, `address2`, `city`, `state`, `zip`, `phone` FROM oldtable; |
Categories: How-To's, Technology Copy, Dupe, Duplicate, howto, Insert, Insert Into, Insert Select, mysql, select, SQL, Table, tips
| 
No comments
