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

The following to understand the main types of mysql database, I believe you will benefit a lot after reading, the text in the essence is not much, hope that the main types of mysql database this short content is what you want.

Data type storage range bytes TINYINT has symbolic values:-128to127(-to)

Unsigned values: 0 to 255 (0 to) 1SMALLINT has symbolic values:-32768 to 32767 (-)

Unsigned values: 0 to 65535 (0 to-1) 2MEDIUMINT has symbolic values:-8388608 to 8388607 (-)

Unsigned values: 0 to 16777215 (0 to) 3INT has symbolic values:-

No symbolic value: 0-14BIGINT has a symbolic value:-

Unsigned values: 0 to-18 floating-point data type precision FLOAT [(MMagar D)] 6-7 places after the decimal point (commonly used) DOUBLE [(MMagazine D)]

14-15 places after the decimal point

Date time Type date Type Storage Space (Bytes) date format range datetime8YYYY-MM-DD HH:MM:SS1000-01-01 00:00:00 ~ 9999-12-31 23:59:59timestamp4YYYY-MM-DD HH:MM:SS1970-01-01 00:00:01 ~ 2038date3YYYY-MM-DD1000-01-01 ~ 9999-12-31year1YYYY1901~2155time2HH:MM:SS-838:59:59 ~ 838 31year1YYYY1901~2155time2HH:MM:SS-838:59:59 59 character column Type description 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.