1.

What are the Numeric Data Types in MySQL?

Answer»

MySQL has numeric data TYPES for integer, fixed-point, floating-point, and BIT values, as shown in the table below. Numeric types can be signed or UNSIGNED, except BIT. A special ATTRIBUTE enables the automatic generation of sequential integer or floating-point COLUMN values, which is useful for applications that require a series of unique identification numbers.

Type NameMeaning
TINYINTVery Small Integer
SMALLINTSmall Integer
MEDIUMINTMedium-sized Integer
INTStandard Integer
BIGINTLarge Integer
DECIMALFixed-point number
FLOATSingle-precision floating-point number
DOUBLEDouble-precision floating-point number
BITBit-field


Discussion

No Comment Found

Related InterviewSolutions