php UNSIGNED ZEROFILL

如下例：

 >mysql>CREATE TABLE shop(
 >article INT(4) UNSIGNED ZEROFILL DEFAULT '0000'   NOT NULL,
 >dealer CHAR(20) DEFAULT '' NOT NULL,
 >price DOUBLE(16,2) DEFAULT '0.00' NOT NULL,
 >PRIMARY KEY(article,dealer));
 mysql>INSERT INTO shop VALUES
 ->(1,'A',3.45),(1,'B',3.99),(2,'A',10.99),
 ->(3,'B',1.45),(3,'C',1.69),(3,'D',1.25),
 ->-(4,'D',19.95);

通过上图可以看出，UNSIGNED ZEROFILL是给article赋0000这种参数形式的；