Use the decimal point for the sum float Type in mysql

Method 1:The best way is to change the float field to decimal (16, 6 ). Specific Method: you can set a temporary field and accurately copy it with the MySQL keyword binary.
Method 2:Use the binary keyword. The specific operation is "select sum (binary field name (float type ))"
BINARY is not a function, but a type conversion operator. It is used to force the string following it to be a BINARY string.
Example:
Copy codeThe Code is as follows:
"Select sum (a. number * binary (B. price) as total
From ler_card as
Left join ler_items as B on a. itemId = B. itemId
Where user_id = 1"