How can i copy one MySQL table contents to another table? - GoFuckYourself.com

brizzad · 08-31-2004, 12:20 PM

I was trying to upgrade some forums, and did something wrong along the way, long story short, all of my threads/posts/users are stored in one table and they need to be moved over to the table that my forums are looking for

is there a simple query i can run?

rickholio · 08-31-2004, 12:28 PM

You can either rename the table:

RENAME TABLE tbl_name TO new_tbl_name

Or recreate the table in the correct spot and insert them:

INSERT INTO new_table SELECT * FROM old_table

HTH. HAND.

brizzad · 08-31-2004, 12:34 PM

Quote:

Originally posted by rickholio
You can either rename the table:

RENAME TABLE tbl_name TO new_tbl_name

Or recreate the table in the correct spot and insert them:

INSERT INTO new_table SELECT * FROM old_table

HTH. HAND.

thanks

Calvinguy · 08-31-2004, 01:04 PM

phpmyadmin usually take care of all my mysql actions

08-31-2004, 12:20 PM	#1
brizzad holla Join Date: Jul 2003 Location: KFC Posts: 11,769	How can i copy one MySQL table contents to another table? I was trying to upgrade some forums, and did something wrong along the way, long story short, all of my threads/posts/users are stored in one table and they need to be moved over to the table that my forums are looking for is there a simple query i can run?

08-31-2004, 12:28 PM	#2
rickholio Confirmed User Industry Role: Join Date: Jan 2004 Location: Nor'easterland Posts: 1,914	You can either rename the table: RENAME TABLE tbl_name TO new_tbl_name Or recreate the table in the correct spot and insert them: INSERT INTO new_table SELECT * FROM old_table HTH. HAND.

08-31-2004, 01:04 PM	#4
Calvinguy Confirmed User Join Date: Oct 2002 Location: European Union Posts: 1,752	phpmyadmin usually take care of all my mysql actions