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

Question

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

Use 1,2,3,4,5 etc as your autoincrement values, and add leading zeroes only when you need to for display purposes — Mark Baker, Jan 08 '14 at 11:40
Why not just starting from 1 ? You can format that to 001 , 002 in PHP. — Shankar Narayana Damodaran, Jan 08 '14 at 11:40
using phpMyAdmin - no way. You would need to alter your script to INSERT max(ID)+1, because it's not a valid autoincrement way, even more when starting with first record `1. ID` and second `2. 001` — Royal Bg, Jan 08 '14 at 11:41
@ShankarDamodaran how to? what do you mean format? will u plz tell? — sudhakar phad, Jan 08 '14 at 11:56
[sprint()](http://www.php.net/manual/en/function.sprintf.php) is a good place to look for formatting numbers for display with leading zeroes — Mark Baker, Jan 08 '14 at 12:04

Saharsh Shah · Accepted Answer · 2014-01-08T11:46:33.553

9

Use ZEROFILL attribute of column.

Try this:

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

edited Jan 08 '14 at 11:46

answered Jan 08 '14 at 11:41

Saharsh Shah

1 Answers1