mysql的left，right,substr,instr截取字符串，截取小数点float
[ 2013-08-03 09:13:50 | 作者: admin ]
//-----------------------------------------------------------------
select avg(stu_oder_percent) from tb_sch_collect
结果：
avg(stu_oder_percent) :
60.60962
//-----------------------------------------------------------------
select left(avg(stu_oder_percent),4) from tb_sch_collect
结果：
left(avg(stu_oder_percent),4) :
60.6
//-----------------------------------------------------------------
...
阅读全文…
select avg(stu_oder_percent) from tb_sch_collect
结果：
avg(stu_oder_percent) :
60.60962
//-----------------------------------------------------------------
select left(avg(stu_oder_percent),4) from tb_sch_collect
结果：
left(avg(stu_oder_percent),4) :
60.6
//-----------------------------------------------------------------
...
阅读全文…
1
