Question: what is the difference between float and decimal in mysql?
Answer: FLOAT is accurate to approximately 7 decimal places, and DOUBLE upto 14. Decimal's declaration and functioning is similar to Double. But there is one big difference between floating point values and decimal (numeric) values. ... A Decimal type can store a Maximum of 65 Digits, with 30 digits after decimal point.