Shulou(Shulou.com)06/01 Report--

Database data types are ×××, floating point type, character type, each data type has its own use range, and C language and Java and other languages have similar points, here to explain

integer has:

1. TINYINT signed values: -128 to 127 (-2^7 to 2^7 -1), unsigned values: 0 to 255 (0 to 2^8-1)

2. SMALLINT Signed values: -32768 to 32767 (-2^15 to 2^15 -1) Unsigned values: 0 to 65535 (0 to 2^16-1)

3. MEDIUMINT Signed value: (-2^23 to 2^23 -1) Unsigned value (0 to 2^24-1)

4. INT signed value (-2^31 to 2^31 -1) unsigned value (0 to 2^32-1)

5. BIGINT signed values (-2^63 to 2^63 -1) unsigned values (0 to 2^64-1)

Floating point type:

FLOAT [(M,D)] single precision, accurate to approximately 7 decimal places,M is the total number of digits, D is the number of digits after the decimal point

2. DOUBLE [(M,D)] double precision, accurate to approximately 16 decimal places

Character Type:

CHAR (M) M bytes, 0

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.