Anonymous
Anonymous Asked in Cars &Transportation · 2 weeks ago

What is exact numeric data type in SQL?

Contents
  1. What is exact numeric data type?
  2. What is numeric data type in MySQL?
The exact numeric data types are SMALLINT , INTEGER , BIGINT , NUMERIC(p,s) , and DECIMAL(p,s) . Exact SQL numeric data type means that the value is stored as a literal representation of the number's value. The approximate numeric data types are FLOAT(p) , REAL , and DOUBLE PRECISION . 18 апр. 2017 г.


What is exact numeric data type?

The exact numeric types are INTEGER , BIGINT , DECIMAL , NUMERIC , NUMBER , and MONEY . Approximate numeric types, values where the precision needs to be preserved and the scale can be floating. The approximate numeric types are DOUBLE PRECISION , FLOAT , and REAL .

What is numeric data type in MySQL?

MySQL Numeric Types MySQL supports all standard SQL numeric data types which include INTEGER, SMALLINT, DECIMAL, and NUMERIC. It also supports the approximate numeric data types (FLOAT, REAL, and DOUBLE PRECISION). The keyword INT is a synonym for INTEGER, and the keywords DEC and FIXED are synonyms for DECIMAL.

Related Questions

Relevance
Write us your question, the answer will be received in 24 hours