MySQL5.7新特性：Online ALTER TABLE

最新推荐文章于 2024-08-29 06:04:01 发布

kf_panda

最新推荐文章于 2024-08-29 06:04:01 发布

阅读量2.4k

点赞数

分类专栏： MySQL5.7新特性

本文链接：https://blog.csdn.net/gua___gua/article/details/52919772

版权

MySQL5.7新特性专栏收录该内容

6 篇文章 0 订阅

订阅专栏

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)