rename 1、Rename table語句用來重命名一個或多個表名 `RENAME TABLE old_table TO new_table;` 當想讓兩個表名相互調換時，可以執行語句 ~~~ RENAME TABLE old_table TO tmp_table, new_table TO old_table, tmp_table TO new_table; ~~~ Rename table能將表中的數據，索引，主鍵定義都自動轉換到新表下，但視圖和對原表分配的權限不能自動轉換到新表，需要手動執行 ~~~ mysql> rename table students to students_test; Query OK, 0 rows affected (0.03 sec) mysql> show create table students_test; +---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | students_test | CREATE TABLE `students_test` ( `sid` int(11) DEFAULT NULL, `sname` varchar(20) DEFAULT NULL, `sex` int(11) DEFAULT NULL, UNIQUE KEY `idx_st_sid` (`sid`), KEY `idx_st_union` (`sname`,`sex`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | mysql> select * from v_students_female; ##原有視圖查詢失敗 ERROR 1356 (HY000): View 'test.v_students_female' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them ~~~