Store Float in MySQL

Storing a float number in MySQL, you must specify the column's precision and scale.

CREATE TABLE `test` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `value` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

• 10: is the precision, which is the total number of digits.
• 2: is the scale, which is the number of digits after the decimal point.

Reference

• Fixed-Point Types (Exact Value) - DECIMAL, NUMERIC