|
5.7之前是不支持对索引重命名的，这次添加了对所有的重命名语法，并且是in place方式。
5.7 官方文档：
ALTER TABLE now supports a RENAME INDEX clause that renames an index. The change is made in place without a table-copy operation. It works for all storage engines.
语法：
ALTER TABLE tbl_name RENAME {INDEX|KEY} old_index_name TO new_index_name;
示例：
mysql>
mysql> create table panda(id int not null,name varchar(100),primary key(id),index idx_name(name));
Query OK, 0 rows affected (0.39 sec)
mysql> alter table panda rename INDEX idx_name to idx_name_new;
Query OK, 0 rows affected (0.22 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql>
mysql> show create table panda;
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| panda | CREATE TABLE `panda` (
`id` int(11) NOT NULL,
`name` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_name_new` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
| 
转播
