编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE student (
    son char(9),
    sname char(20),
    ssex char(2),
    sage char(40),
    saddress char(100),
    PRIMARY KEY(son)
);
INSERT INTO student VALUES (1,'肖学宇','女','18','安徽');
INSERT INTO student VALUES (2,'岳向萍','女','18','河南');
INSERT INTO student VALUES (3,'周佳玉','女','18','西安');
INSERT INTO student VALUES (4,'徐贝贝','女','18','湖北');


SELECT * FROM student;

SELECT * FROM student
WHERE sname='徐贝贝';

SELECT * FROM student
WHERE sage=18;

UPDATE student
SET sage = 17
WHERE sname = '徐贝贝';

DELETE FROM student
WHERE sname='徐贝贝';

DELETE FROM student;