MySQL的简单查询语句

查询：

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 取价格的平均值