decimal(7 2) mysql code example

Example 1: mysql alter decimal precision

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

Example 2: mysql type for large numbers with many decimal

CREATE TABLE tab(col DECIMAL(20,10));