AUTO_INCREMENT start from zero

admin

Administrator
Staff member
ello,

Does anyone know in MySQL the AUTO_INCREMENT field can generate/start from zero?

example
+-----------+------------------+
| colour_id | colour |
+-----------+------------------+
| 000 | -Unknown Colour- |
+-----------+------------------+
| 001 | Red |
+-----------+------------------+
| 002 | Blue |
+-----------+-------------------
etc...

If so, how?

Thanks!
annalise
 
Back
Top