what data type for 11.1234 in mysql?

Question

i wonder what data type i should use for storing 11.1234 in mysql?

varchar or int? they got some decimal data type?

thanks

Answer 1

FLOAT or DECIMAL is probably best.

From the MySQL manual:

The FLOAT and DOUBLE data types are used to represent approximate numeric data values [...] The DECIMAL and NUMERIC data types are used to store exact numeric data values. In MySQL, NUMERIC is implemented as DECIMAL. These types are used to store values for which it is important to preserve exact precision, for example with monetary data.