MySQL间隙锁/Next-key演示 1. 建表建索引:
CREATE TABLE user(
id int primary key,
name varchar(20),
age int) ENGINEInnoDB;CREATE INDEX index_age ON user(age);INSERT INTO user(id,name,age) VALUES (1,xiaoming,12);
INSERT INTO user(id,name,age) VA…
通过mysql -uroot -p进入数据库,创建数据库:create database databaseName;。use databaseName出现错误:Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with…