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中代表什么?
发布评论