mysql中sum float类型使用小数点的方法

复制代码 代码如下:

    "select sum(a.number*binary(b.price)) as total
        from ler_card as a
        left join ler_items as b on a.itemId=b.itemId
        where user_id=1"