How to store id like this 000001 in mysql?

Question

how can I store number like this 000001 in mysql, and increment it everytime a new user register?

Answer 1

You can add zerofill to your (autoincrement) id column to do what the name suggests. It will make your datatype unsigned.

see also

• How can I set autoincrement format to 0001 in MySQL?
• What is the benefit of zerofill in MySQL?

Answer 2

Try adding ZEROFILL attribute to the field.

CREATE Table tableName (
   mykey int(6) zerofill not null auto_increment, 
   primary key(mykey)
);

will result every new record:

000001