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