Answers for "insert decimal type in mysql"

mysql decimal

column_name DECIMAL(precision, scale)
-- DECIMAL stores exact numeric values with a fixed decimal point.
-- The precision is the total number of digits before AND after the decimal point.
-- The scale is the number of digits after the decimal point.

mysql alter decimal precision

ALTER TABLE YourTableNameHere MODIFY COLUMN YourColumnNameHere decimal(4,2)