mysql how to set a number of decimals code example

Example 1: mysql alter decimal precision

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

Example 2: mysql decimal

column_name DECIMAL(5,2)