Mega Code Archive

 

Categories / MySQL Tutorial / Data Types

 

DECIMAL[(M[,D])] [UNSIGNED] [ZEROFILL]

A packed exact fixed-point number. M is the total number of digits. D is the number of digits after the decimal point. The decimal point and (for negative numbers) the '-' sign are not counted in M. The maximum number of digits (M) is 65. The maximum number of decimals (D) is 30. If D is omitted, the default is 0. If M is omitted, the default is 10. DEC[(M[,D])] [UNSIGNED] [ZEROFILL], NUMERIC[(M[,D])] [UNSIGNED] [ZEROFILL], FIXED[(M[,D])] [UNSIGNED] [ZEROFILL] are synonyms for DECIMAL.