Method of using decimal point for Sum float type in Mysql _mysql

method One: the best approach is to change the float field to decimal (16,6). Specific methods: You can set a temporary field, combined with the MySQL keyword binary for accurate replication and so on.
method Two: use binary keyword to solve. The specific action is "Select SUM (binary field name (float type)")
Binary is not a function, it is a type conversion operator, and it is used to force the string behind it to be a binary string
Example:

Copy Code code as follows:

"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 "