在MySQL中，zerofill有什么好处? [英] What is the benefit of zerofill in MySQL?

问题描述

我只想知道为MySQL中的INT数据类型定义 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

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