I want an auto incremented column "ID"starting with 001 in mysql-php? Using phpmyadmin how to do that

php mysql sql alter zerofill

sudhakar phad · Jan 8, 2014 · Viewed 7.2k times · Source

I want to start my auto incrementation of column from 001,002,003 like that ..plz tell me how to do that..

Using phpMyadmin.

 1. ID
 2. 001
 3. 002
 4. 003
 5. .
 6. .
 7. .
 like above shown..

Answer

Use ZEROFILL attribute of column.

Try this:

ALTER TABLE tableName CHANGE `columnName` `columnName` INT(3) ZEROFILL;