update scp_fepstatus
set SCP_VALID_RATA = TRUNCATE(SCP_RECORD_RECEIVE/SCP_RECORD_SEND,2)
这里计算了两个数相除,2表示结果小数点后面的位数,比如:1/3 =0.33
set SCP_VALID_RATA = TRUNCATE(SCP_RECORD_RECEIVE/SCP_RECORD_SEND,2)
这里计算了两个数相除,2表示结果小数点后面的位数,比如:1/3 =0.33