Starting the AUTO_INCREMENT with zero
I need some help with MySQL. I have id
col开发者_JAVA百科umn on my news
table with AUTO_INCREMENT and as usually it assign id=1
for the very first news, id=2
for the second and etc. But I want it to start with 001
instead of 1
, then 002
,003
and so. How can I do that?
Use a numeric field and set the field to ZEROFILL. More on how to use ZEROFILL here.
精彩评论