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)

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

delete from student where role=1;

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

delete from student;