GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Any SQL gurus in the house? Can you help?

react · 09-26-2008, 11:41 AM

Forget the export..

insert ignore into table2 select * from table1;

or if you have a disparate structure:

insert ignore into table2 (some, fields, here) select some, fields, here from table1;

Glad it worked out.

09-26-2008, 11:41 AM
react Confirmed User Industry Role: Join Date: Sep 2003 Location: NZ Posts: 673	Forget the export.. insert ignore into table2 select * from table1; or if you have a disparate structure: insert ignore into table2 (some, fields, here) select some, fields, here from table1; Glad it worked out. __________________ -- react