GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   How can i copy one MySQL table contents to another table? (https://gfy.com/showthread.php?t=349493)

brizzad 08-31-2004 12:20 PM

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?

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 :thumbsup

Calvinguy 08-31-2004 01:04 PM

phpmyadmin usually take care of all my mysql actions


All times are GMT -7. The time now is 07:07 AM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123