CREATE TABLE student(stuName VARCHAR(30),carId CHAR(7),carPrice INT);studentstudent;

//使用SQL添加数据

INSERT INTO student(stuName,stuAge,stuAddr)VALUES('小冷','16','北京');

INSERT INTO student VALUES('小小','15','燕京');

INSERT INTO student(stuName,stuAge)VALUES('小海','17');

//WHERE 限定条件

DELETE FROM student WHERE stuAddr='吉林'AND stuAge>19;

DELETE FROM student WHERE stuAddr='长春'OR stuAge=16;

//单字段修改

UPDATE student SET stuAge='25'WHERE stuAddr='北京';

//多字段修改  用逗号分隔

UPDATE student SET stuAge='30',stuAddr='燕京'WHERE stuName='小红';

//查询

SELECT stuName,stuAge FROM student WHERE stuAddr='北京';

//升序排列

SELECT stuName ,stuAge FROM student ORDER BY stuAge ASC;

//降序排列

SELECT stuName,stuAge FROM student ORDER BY stuAge DESC;

//取出前3条记录，第一个参数表示从哪开始（下标），第二个参数表示取出的个数

SELECT stuName,stuAge,stuAddr FROM car LIMIT 0,3;

//取出第二个到第四个

SELECT stuName,stuAge,stuAddr FROM car LIMIT 1,3;

//去除重复数据

SELECT DISTINCT stuAge FROM car

//分组数据

//统计男女各有多少人

SELECT stuSex,COUNT (*)FROM car GROUP BY stuSex;