首先创建一张 students 表
SQL脚本如下:
create table students( id int primary key auto_increment, age int, name varchar(20), city varchar(20) ) character set utf8; insert into students values(null, 22, 'lisa', '杭州'); insert into students values(null, 16, 'rock', '上海'); insert into students values(null, 20, 'jack', '深圳'); insert into students values(null, 21, 'rose', '北京');