Is there a number type in mysql that supports 0 at the beginning?

Question

MySQL

For example, I want to store the number 00254 (so that zeros are not cut out when saving)
I know about text, varchar and other types. And are there numbers?

Answer 1

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

https://dev.mysql.com/doc/refman/5.5/en/numeric-ty...
That's how you can.

Answer 2

If the task is to save in its original form, then store it in string.
If the number of characters is always known (in this example, 5), and it is required to pad with zeros:

>>> str_pad('254', 5, '0', STR_PAD_LEFT)
=> "00254"

Answer 3

what does life-giving PHP do to people!
and they also say...
TS, php.spb.ru/php/printf.html will solve your problem