MYSQL 判断小数点位数
取出小数点多余3位的小数
select score from student
where LOCATE('.',score) > 0
and LENGTH(SUBSTRING_INDEX(score,'.' ,- 1)) >=3
select score from student
where LOCATE('.',score) > 0
and LENGTH(SUBSTRING_INDEX(score,'.' ,- 1)) >=3