mySQL zerofill

[wing328]

Just a simple questions. What means by zerofill for the integer type in mySQL??

Thanks,
William

[Anon]

no zerofill= 21
zerofill = 000000021

[Anon]

Zerofill automatically adds leading zeros to the number. Keep in mind that all zerofill columns are automatically unsigned.

Try this:
CREATE TABLE test(id INT ZEROFILL);
DESCRIBE test;

You will see that the unsigned attribute is automatically added to the column.
Check out:
http://www.mysql.com/doc/C/R/CREATE_TABLE.html