MySQL操作学生表

创建学校表

CREATE TABLE `student` (
`id` INT ( 4 ) NOT NULL auto_increment COMMENT '学号',
`name` VARCHAR ( 20 ) NOT NULL COMMENT '名字',
`sex` INT ( 2 ) NOT NULL COMMENT '性别',
`phone` VARCHAR ( 11 ) NOT NULL COMMENT '电话',
`role` INT ( 2 ) NOT NULL COMMENT '角色',
`score` INT ( 3 ) NOT NULL COMMENT '成绩',
PRIMARY KEY ( `id` ) 
) COMMENT = '学生信息表';

添加学生信息

insert into student values
(default,‘zhangsan',2,'13837689458',1,54),
(default,‘lisi',2,'13837689458',2,90),
(default,‘wangwu',1,'13837689458',3,94),
(default,‘zhaoliu',2,'13837689458',3,82)

修改lisi的电话

update student set phone='18066666666'where name='lisi';

删除role是1的对象

delete from student where role=1;

查询名字带有z的

select * from student where name like 'z%';

清空表

delete from student;