INT(1)在MySQL中代表什么? [英] What does INT(1) stand for in MySQL?

问题描述

INT(1)-我知道，1并不表示1位数字，它仅表示客户端输出的显示格式.

INT(1) - I know, 1 does not mean 1 digit, it represents client output display format only.

但这表示什么

我已经将YEAR声明为int(1)，我仍然看到所有4个字节.请告诉我INT(1)是什么意思?

i have declared YEAR as int(1), I still see all 4 bytes. please tell me what does INT(1) means ?

SELECT * FROM TEST_USERDB;

+----+--------+------+
| ID | NAME   | YEAR |
+----+--------+------+
|  1 | abcccc | 2012 |
|  2 | stack  |   99 |
+----+--------+------+

推荐答案

unsigned int的最大值为4294967295，无论其 INT(1)或int(10)，将使用4个字节的数据.

An unsigned int has the max value of 4294967295 no matter if its INT(1) or int(10) and will use 4 bytes of data.

那么，方括号中的数字是什么意思?差不多来了 向下显示，其称为显示宽度.显示宽度为 从1到255之间的数字.如果需要所有 您的整数值将显示".如果您在该行上启用填零， 对于int(1)，该字段的默认值为0，对于0000000000，该字段的默认值为 int(10).

So, what does the number in the brackets mean? It pretty much comes down to display, its called the display-width. The display width is a number from 1 to 255. You can set the display width if you want all of your integer values to "appear". If you enable zerofill on the row, the field will have a default value of 0 for int(1) and 0000000000 for int(10).

了解详情

这篇关于INT(1)在MySQL中代表什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！