how to validate a decimal datatype in mysql code example Example: mysql type for large numbers with many decimal CREATE TABLE tab(col DECIMAL(20,10));