Thread: renaming large table
11-02-11, 13:29 #1Registered User
- Join Date
- Sep 2010
Unanswered: renaming large table
I found out that the renaming of large tables (more than 1000000 entries) takes some time.
I need to rename one table so I can give its name to the other (I want to keep both tables)
ALTER TABLE t1 RENAME TO t3; ALTER TABLE t2 RENAME TO t1;