- 选择
select * from tabel where 范围
- 插入
insert into table (field,fled) values (values,…)
- 删除
delete table where 范围
- 更新
update table set field = value/where 范围
- 查找
select * from table where field like ‘%values%’
- 排序
select * from table order by field1,field2 (desc)
- 总数
select count as totalcount form table
- 求和
select sum(field)as totalcount from table
- 最大
select max (field1) as maxvalue from table
- 最小
select min(field) as minvalue from table
- 基本的牢记,换在复杂的数据库也可以行云流水
基本SQL语句
最新推荐文章于 2024-07-07 08:52:27 发布