Shulou(Shulou.com)05/31 Report--

This article introduces the introduction and usage of Mysql data type, the content is very detailed, interested friends can refer to, hope to be helpful to you.

Data type

Numerical type

Integer number

Int (m) four bytes (- 2.1 billion ~ 2.1 billion)-java:int

Bigint (m) eight bytes (to the power of 18)-java:long

Floating point number

Float (m) single precision floating point 8-bit precision 4 bytes m total d decimal places-java:float

Double (m) double precision floating point number 16 bit precision 8 bytes m total number d decimal number-java:float

Fixed point number

Floating-point types always store approximate values in the database, while fixed-point types store exact values.

Decimal (m) d) m

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.