set SCP_VALID_RATA = TRUNCATE(SCP_RECORD_RECEIVE/SCP_RECORD_SEND,2)
这里计算了两个数相除,2表示结果小数点后面的位数,比如:1/3 =0.33
mysql除法精度
原文:http://blog.csdn.net/calmreason/article/details/18733495