CUDI
- 插入一条数据
insert into 表名(字段名1,字段名2) values(字段值1,字段值2) - 删除一条数据
delete from 表名 where 字段名1=字段值1
delete from 表名 //删除表里所有数据 - 查询数据
select * from 表名 - 更新数据
update 表名 set 字段名1 = 字段值1 where 字段名1 = 字段值2
update 表名 set 字段名1 = 字段值1 //修改表里所有数据
select
- 基本查询:select * from table_name
- 字段查询:select fileds from table_name
- 条件查询:select * from table_name where a=1
- 排序:select * from table_name order by b desc
- 分页:select * from table_name order by b limit 10 offset 0
- 去重:select distinct gender from table_name
查询条件
- 比较:等于=、大于>、小于<、不等于<>
- 通配:WHERE FIELDS LIKE ‘%or%’
- 范围限定:WHERE PRICE BETWEEN 10 AND 20
- 子集限定:WHERE COUNTRY IN (‘Gernamy’,‘France’,‘UK’)
- 逻辑关系:and or not
- 基本语法:group by 字段 having 条件
- 常用函数:count、max、min、sum、avg