mysql data format 2 decimal places code example Example: mysql type for large numbers with many decimal CREATE TABLE tab(col DECIMAL(20,10));