Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Data type and create operation database

2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report