- 特殊符号
大于:>
小于:<
大于等于:>=
小于等于:<=
- sql函数
1、if 语句
select if(sva=1,"男","女") as ssva from taname where id = '111';
2、avg 平均数
select avg(pi) as pi_avg from price where category=55
大于:>
小于:<
大于等于:>=
小于等于:<=
1、if 语句
select if(sva=1,"男","女") as ssva from taname where id = '111';
2、avg 平均数
select avg(pi) as pi_avg from price where category=55