Numeric Data Type in MySQL|| Mysql Tutorial Series|| Code With Neha
The numeric data type in mysql is one of the most widely used data types to store numeric values. Below is the list of data types that are included under the numeric data type in SQL:
INTEGER or INT
SMALL INT
DECIMAL or DEC or FIXED
NUMERIC
FLOAT
REAL
DOUBLE
PRECISION
Numbers in SQL can be either exact numbers (like NUMERIC, DECIMAL, INTEGER, BIGINT, and SMALL INT) or approximate numbers (like DOUBLE PRECISION, FLOAT, and REAL). In exact numeric type, precision and scale are preserved.
For example, we can fix the significant digits and precision for a numeric data type. On the other, in approximate numeric types, the precision needs to be preserved, but the scale is not (it can be floating)
The Integer Data Types
The integer data type is used to store whole numbers (numbers without the decimal point or simply non-decimal numbers). The numbers can be negative. The integer data type consists of SMALLINT, INTEGER, TINYINT, and BIGINT.
Float Data Types
The float data type is used to store approximate numeric values just like Integer Data Types are used. The floating data type consists of two parts, namely significant value(M) and exponent value(D). The significant value is a signed numeric value that is the maximum number of digits, the precision.
that's all for today Hope you all will get some help from this video
If it's so then don't forget to subscribe my channel Code with Neha and press the Bell Icon for Regular Updates
See you in the next video till then Stay Safe Stay Happy
#mysql
#mysqltutorial
#mysqltutorialforbeginners
#mysqldba
#mysqlserver
#mysqltutorials
#mysqldatabase
#mysqldatabasetutorial
#coding
#datatypes
#numericdatatype
#numericdatatypes
#mysqldatatypes
#datatypesinmysql
#datatypesinsql
#numericdatatypes
#numericdatatypesinmysql
#numericdatatypesinsql