discuss various types of numeric field base ?
Answers
Answered by
9
Numeric Data Types
Numeric Data Type Overview
Overview and usage of the numeric data types
TINYINT
Tiny integer, -128 to 127 signed
BOOLEAN
Synonym for TINYINT(1)
SMALLINT
Small integer from -32768 to 32767 signed
MEDIUMINT
Medium integer from -8388608 to 8388607 signed
INT
Integer from -2147483648 to 2147483647 signed
INTEGER
Synonym for INT
BIGINT
Large integer
1
DECIMAL
A packed "exact" fixed-point number.
DEC, NUMERIC, FIXED
Synonyms for DECIMAL
FLOAT
Single-precision floating-point number
DOUBLE
Normal-size (double-precision) floating-point number
DOUBLE PRECISION
REAL and DOUBLE PRECISION are are synonyms for DOUBLE
BIT
Bit field type
Floating-point Accuracy
Not all floating-point numbers can be stored with exact precision.
pls mark it brainliest✨✨✨
Numeric Data Type Overview
Overview and usage of the numeric data types
TINYINT
Tiny integer, -128 to 127 signed
BOOLEAN
Synonym for TINYINT(1)
SMALLINT
Small integer from -32768 to 32767 signed
MEDIUMINT
Medium integer from -8388608 to 8388607 signed
INT
Integer from -2147483648 to 2147483647 signed
INTEGER
Synonym for INT
BIGINT
Large integer
1
DECIMAL
A packed "exact" fixed-point number.
DEC, NUMERIC, FIXED
Synonyms for DECIMAL
FLOAT
Single-precision floating-point number
DOUBLE
Normal-size (double-precision) floating-point number
DOUBLE PRECISION
REAL and DOUBLE PRECISION are are synonyms for DOUBLE
BIT
Bit field type
Floating-point Accuracy
Not all floating-point numbers can be stored with exact precision.
pls mark it brainliest✨✨✨
sonu29325:
my real name is Chiranjeeb nd sonu is pet name
Similar questions
Social Sciences,
7 months ago
Physics,
7 months ago
Biology,
1 year ago
Math,
1 year ago
Math,
1 year ago