1.用命令创建表
CREATE TABLE student(id INT auto_increment not null primary key,
sno INT(10),
sname VARCHAR(32),
depa VARCHAR(32),
age TINYINT(2),
sex VARCHAR(6)
)
2.添加数据
INSERT into student VALUES(null,'20122222','计算机系','李勇','20','男')
CREATE TABLE student(id INT auto_increment not null primary key,
sno INT(10),
sname VARCHAR(32),
depa VARCHAR(32),
age TINYINT(2),
sex VARCHAR(6)
)
INSERT into student VALUES(null,'20122222','计算机系','李勇','20','男')