// 建表
CREATE TABLE stu (
ID int(10) NOT NULL AUTO_INCREMENT,
NAME varchar(8) NOT NULL,
AGE int(2) NULL,
SEX varchar(12) NULL,
AD varchar(50) NULL,
`PHONENUMBER` varchar(20) NULL,
PRIMARY KEY (`ID`)
);
// 插入语句
INSERT INTO stu VALUES(1, 'LIQIANG', 19, 'MAN', 'LINXILU', ' 133388456698' ),
(2, 'WANGLEL', 18, 'WOMAN', 'XUESHILU', ' 18684122654' ),
(3, 'TANGXUE', 18, 'WOMAN', 'BOXUELU', '19336549998' ),
(4, 'LIUHUI', 17, 'MAN', 'NINGBOLU', '16125497825');