Hint. MySQL Server: If you are comparing FLOAT or DOUBLE columns with numbers that have decimals,
you cannot use equality (=) comparisons.
This problem is common in most computer languages because not all floating-point values
can be stored with exact precision. In some cases, changing the FLOAT to a DOUBLE fixes this.
MySQL : Which one of the following query is correct:
a) UPDATE table SET field1=3, field2=4 WHERE field0 = 10
b) UPDATE table SET field1=3 AND field2=4 WHERE field0 = 10