ZEROFILL in mysql stands for zero padding. Is the format field name int(M)? Zero padding. When inserting data, when the length of the value of this field is less than the defined length, the value will be preceded by the corresponding 0. Zerofill defaults to int( 10). When using zerofill, unsigned attributes are automatically added by default. With unsigned attributes, the range of values is twice the original value.

Extended data:

Tools/materials: management studio. ?

1. First, on the desktop, click the "Management Studio" icon. ?

2. In the interface, click the "New Query" option in the upper left corner. ?

3. Then enter the sql statement "Create table staff (id int (11) unsigned zero fill auto _ increment,? Col2 varchar(20) is not NUL. Primary key (id),)? "。 ?

4. Then in this interface, click the "Execute" button at the top left. ?

5. Finally, in this interface, the display command has been successfully completed.