CREATE TABLE user
(id
int(11) NOT NULL AUTO_INCREMENT,username
varchar(50) DEFAULT NULL,password
varchar(100) DEFAULT NULL,age
int(11) DEFAULT NULL,
PRIMARY KEY (id
),
KEY password_index
(password
) USING BTREE,
KEY username_index
(username
) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10063003 DEFAULT CHARSET=utf8;
3个索引树分别是 id、password、username
B+TREE数据结构这个网站有 https://www.cs.usfca.edu/~galles/visualization/Algorithms.html