INT(1)在MySQL中代表什么?

本文介绍了INT(1)在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).

了解详情