GoFuckYourself.com - Adult Webmaster Forum - View Single Post - How can i copy one MySQL table contents to another table?

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.

08-31-2004, 12:28 PM
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.