Primary Key from 1 to 01, 2 to 02, etc

Question

I have a primary key field (news_id) in the news table

it start from 1, 2, 3, 4 and so on..

However, I like to change to 01, 02, 03, 04,e tc ... is that possible?

If not, how can that be done in PHP?

Answer 1

Manipulating the keys directly is a bad idea in 99% of cases.

The best way to go is probably to change the format when outputting the keys like shown in this question:

$key = 4;
echo sprintf('%02d', $key); // outputs 04