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

alter, mysql, php, sql, zerofill

Solution

Use ZEROFILL attribute of column.

Try this:

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

Problem

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

Original source