在做数据显示的时候,经常会遇到数据所占百分比的问题。下面说说Mysql怎么对数据库数据每行进行百分比运算
1.原始数据,如下图:(我需要计算pass次数百分比,即需要得到pass次数/(pass+fail+miss)次数
2.算出每行数据pass次数的百分比,用下面语句:
SELECT *,concat(round(pass/(pass+fail+miss)*100,0),'%') as passed FROM testdata
3.算出每行数据pass次数的百分比和fail次数的百分比,用下面语句:
SELECT *,concat(round(pass/(pass+fail+miss)*100,0),'%') as passed,
concat(round(fail/(pass+fail+miss)*100,0),'%') as failed FROM testdata