select t.totalprice*(select cast(s.value as decimal(3,2)) from sys_param s where s.name='积分') as info from trade_info tselect t.totalprice*(select cast(s.value as dec
阅读背景：
mysql 做乘法 varchar转decimal
来源：互联网
分享到：
