Mega Code Archive

 

Categories / MySQL / Command Mysql

 

RENAME TABLE allows you to rename multiple tables, which allows you to do things such as swap the names of two tables in a s

RENAME TABLE name1 TO temp_name, name2 TO name1, tmp_name to name2;