GoFuckYourself.com - Adult Webmaster Forum - View Single Post

rowan · 05-21-2009, 09:05 PM

If you're ever scratching your head about a command, do a search for "COMMAND mysql" and the mysql site is usually the first result.

I presume you want something like this...

INSERT INTO table_B (column1,column2) SELECT column1,column2 FROM table_A;

Back up your data first.

05-21-2009, 09:05 PM
rowan Too lazy to set a custom title Join Date: Mar 2002 Location: Australia Posts: 17,393	If you're ever scratching your head about a command, do a search for "COMMAND mysql" and the mysql site is usually the first result. I presume you want something like this... INSERT INTO table_B (column1,column2) SELECT column1,column2 FROM table_A; Back up your data first.