Home > Database > Mysql Tutorial > MySQL5.7 加强了在线DDL(varchar字符集)

MySQL5.7 加强了在线DDL(varchar字符集)

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-07 16:48:22
Original
1100 people have browsed it

在MySQL5.6引入了在线DDL,添加字段和辅助索引不锁表,但修改字段属性是锁表的。请见:http://hcymysql.blog.51cto.com/5223301/1370546如今在MySQL5.7,加强了

在MySQL5.6引入了在线DDL,添加字段和辅助索引不锁表,但修改字段属性是锁表的。请见:


如今在MySQL5.7,加强了修改varchar字段属性不锁表,例:


参考:

wKiom1RPXGHw_vOAAAQrwxQQrc4177.jpg


BTW:

MySQL5.7还支持更改索引名,不过实用性不高,谁没事闲得改索引的名字?例:

wKioL1RPYh6D6x-jAAK-ZnVnN4A255.jpg

wKiom1RPYciRcsR-AAK5z6fs-bw004.jpg



本文出自 “贺春旸的技术专栏” 博客,请务必保留此出处

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
linux - Installing mysql5.7 on centos
From 1970-01-01 08:00:00
0
0
0
Problems with navicat and MYSQL5.7
From 1970-01-01 08:00:00
0
0
0
Subquery insert fails in MySQL 5.7
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template