Mega Code Archive

 

Categories / MySQL / Command Mysql

 

RENAME TABLE can perform multiple table renaming operations in a single statement

RENAME TABLE t1 TO tmp, t2 TO t1, tmp TO t2;