查询:
seclt * from table 查询所有
select name,name2,name3 from 查询指定返回的字段
根据条件查询:
select * from tableName where Code = 12 单条件查询
select * from tableName where code = 12 and cod2 = 12 多条件查询
select * from table where code = 12 or code = 13 条件或查询
select * from table where price >= 20 and price <=60 范围查询
select * from table where price btween 50 and 60 范围查询
模糊查询
select * from table where card like '%型' %通配符
排序
select * from table where order by card 按照价格升序排列
五:统计函数(聚合函数)
select count(Code) from Car 查询表中有多少条数据
select max(Price) from Car 取价格的最大值
select min(Price) from Car 取价格的最小值
select sum(Price) from Car 取价格的总和
select avg(Price) from Car 取价格的平均值