Thread: How can i copy one MySQL table contents to another table?
View Single Post
Old 08-31-2004, 12:34 PM  
brizzad
holla
 
Join Date: Jul 2003
Location: KFC
Posts: 11,769
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
brizzad is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote