phpmysqlsqlalterzerofill

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

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..
Solution

  • Use ZEROFILL attribute of column.

    Try this: 

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