在 MySQL 中使用 zerofill 有什么好处?

2021-11-20 00:00:00 types mysql unsigned-integer

我只想知道在 MySQL 中为 INT DataType 定义 ZEROFILL 的好处/用途是什么?

I just want to know what is the benefit/usage of defining ZEROFILL for INT DataType in MySQL?

`id` INT UNSIGNED ZEROFILL NOT NULL

推荐答案

当您选择类型为 ZEROFILL 的列时，它会用零填充字段的显示值，直至在列定义.长于显示宽度的值不会被截断.请注意，ZEROFILL 的使用也意味着 UNSIGNED.

When you select a column with type ZEROFILL it pads the displayed value of the field with zeros up to the display width specified in the column definition. Values longer than the display width are not truncated. Note that usage of ZEROFILL also implies UNSIGNED.

使用 ZEROFILL 和显示宽度对数据的存储方式没有影响.它只影响它的显示方式.

Using ZEROFILL and a display width has no effect on how the data is stored. It affects only how it is displayed.

以下是一些示例 SQL，演示了 ZEROFILL 的使用:

Here is some example SQL that demonstrates the use of ZEROFILL:

CREATE TABLE yourtable (x INT(8) ZEROFILL NOT NULL, y INT(8) NOT NULL);
INSERT INTO yourtable (x,y) VALUES
(1, 1),
(12, 12),
(123, 123),
(123456789, 123456789);
SELECT x, y FROM yourtable;

结果:

        x          y
 00000001          1
 00000012         12
 00000123        123
123456789  123456789

相关文章