|
erics, August 8th, 2012 SELECT * FROM yourTable GROUP BY yourField HAVING count(yourField) > 1;
Categories: How-To's, Technology Dupe, Duplicate, Duplicate Records, Duplicate Rows, GROUP BY, GROUP BY HAVING, HAVING, howto, mysql, SQL, tips
| 
No comments
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
