Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What Are Numeric Data Types?

April 26, 2017Data numeric types

0

Posted

What Are Numeric Data Types?

1 Answer

0

Posted

• BIT(n) – An integer with n bits. • BOOL same as BOOLEAN – Boolean values stored in 1 bit. • TINYINT – A small integer stored in 1 byte. • SMALLINT – A small integer stored in 2 bytes. • MEDIUMINT – A medium integer stored in 3 bytes. • INT same as INTEGER – An integer stored in 4 bytes. • BIGINT – An integer stored in 8 bytes. • FLOAT – A single-precision floating-point number stored in 4 bytes. • DOUBLE same as DOUBLE PRECISION – A double-precision floating-point number stored in 8 bytes. • REAL – Same DOUBLE by default. • DECIMAL(m,d) – A fixed-point number with m as the precision (total number of digits) and d as the scale (number of digits after the decimal point).