![]() |
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? |
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. |
Quote:
thanks :thumbsup |
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