1、前序准备 # 测试表 CREATE TABLE student ( id int PRIMARY KEY, name VARCHAR(100) ) Engine=InnoDB CHARSET=utf8; # 测试数据 INSERT INTO