MySQL field structure

Question

I have a MySQL table data type integer field. the value is stored as 1, 2, 3 .., 10000.

I want to format it with starting from 00001, 00002, 0003 etc., (the whole number to be 5 digit).

Is there any function to do?

or how do i set it manually in phpMyAdmin..

Answer 1

You can change the column type to INT(5) ZEROFILL. From the documentation:

When used in conjunction with the optional extension attribute ZEROFILL, the default padding of spaces is replaced with zeros. For example, for a column declared as INT(5) ZEROFILL, a value of 4 is retrieved as 00004.

Example:

CREATE TABLE table1(x INT(5) ZEROFILL);
INSERT INTO table1 VALUES(4);
SELECT * FROM table1;

Result:

00004