数据库的增删查改

增：
insert into test(name, age) values('name', 18);
insert into test(name, age) values('name1', 18),('name2', 18);    #一次性插入多个值
insert into test(name, age) select name,age from test1;    #把某张表中的数据插入

删：
delete from test;
delete from test where id>2 and name='name1';

改：
updata test set name='name2',age=19 where id>12 and name='name1';

查：
select * from test;
select id,name from test where id>2;
select name,age,123 from test;
select name as rname from test;
select * from test where id in (1,3,5,7);
select * from test where id in (select id from test1);
select * from test where id between 5 and 9;    #闭区间，左右都可以取到
通配符
select * from test where name like 'name%';    %匹配无数字符；_匹配一个字符
分页
select * from test limit 10;    取前十条
select * from test limit 0,10;    表示从0开始，取0后面的10条
select * from test limit 10 offset 20;    表示从20开始，取20后的前10条
排序
select * from test order by id desc;    id从大到小排列
select * from test order by id asc;    id从小到大排列
select * from test order by age desc, id asc;    多个不同排序
select * from test order by desc limit 10;    取后十条
分组(聚合函数：count,max,min,sum,avg求平均值)
select max(id),id from test group by sex;    如果遇到相同的sex，只会取最大id的
select count(id),id from test group by sex;    计数
select count(id) as count,id form test group by sex;
select count(id),id from test group by sex having count(id)>2;    对于聚合函数结果进行二次筛选时，必须使用having
select
from
where
group by
order by