AUTO_INCREMENT PRIMARY KEY

[Pavel ŠVARC]

Lubo Slovak wrote:

> V MySQL pouzivam primarny kluc
> int(6) AUTO_INCREMENT PRIMARY KEY
> 
> Vsetko cisluje v poriadku, len ja by som potreboval, aby bolo kazde cislo
> sedemciferne s nulami na zaciatku (000001, 000002, 000003 ...). Je to
> mozne nejak docielit?
myslím že ZEROFILL bude váš kamarád :O)))
"When used in conjunction with the optional extension attribute ZEROFILL, 
the default padding of spaces is replaced with zeroes. For example, for a 
column declared as INT(5) ZEROFILL, a value of 4 is retrieved as 00004."

Stefan