CREATE TABLE student( id int(4) NOT NULL PRIMARY key auto_increment, `name` VARCHAR(20) NOT NULL DEFAULT ‘匿名‘, sex VARCHAR(2) NOT null DEFAULT ‘1‘, phone BIGINT(11), role int(2), score int(4) ) INSERT INTO student VALUES (DEFAULT,‘zhangsan‘,2,13837689458,1,54); INSERT INTO student VALUES (DEFAULT,‘lisi‘,2,18888888888,2,90); INSERT INTO student VALUES (DEFAULT,‘wangwu‘,1,16666666666,3,94); INSERT INTO student VALUES (DEFAULT,‘zhaoliu‘,2,15555555555,3,82); UPDATE student SET Phone=18650170763 WHERE id=2; SELECT*FROM student WHERE score<60; SELECT* FROM student WHERE name LIKE‘z%‘; SELECT * FROM student WHERE role IN (1,3); DELETE FROM student WHERE role=1; DELETE FROM student;