ZEROFILL

Bill,
I have read the link, however it's unclear what is the "specific reason".
Anyway thank you for your time.

regards,
Khazret Sapenov

"Bill Karwin" <bill.DeleteThis@karwin.com> wrote in message
news:cub4ol02ksa@enews3.newsguy.com...
 > Khazret Sapenov wrote:
  > > What is the practical use of ZEROFILL in your case?
 >
 > I have not had a need to use that feature in my projects, but sometimes
 > people have an integer field that must have uniform length, so they
 > prefer to have the leading portion fill with zeroes.
 >
 > For instance:
 >
<a style='text-decoration: underline;' href="http://groups-beta.google.com/group/mailing.database.mysql/browse_thread/thread/44090b6cac8da980/" target="_blank">http://groups-beta.google.com/group/mailing.database.mysql/browse_thre...thread/</a>
 >
 > Regards,
 > Bill K.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: ZEROFILL 

Khazret Sapenov wrote:
 > I have read the link, however it's unclear what is the "specific reason".

The link just demonstrates that there exists a person who has that
requirement to pad integers with zeroes, and the ZEROFILL attribute was
the solution.

I think it's just a convenience. A programmer could format the value
that way after fetching it from the database, but apparently it's a
common enough task that MySQL can do it for you if you need it.

As for why someone would want this, it can help in some documents to
make integers of uniform length, so that they align with each other
regardless of being right- or left-justified.

Regards,
Bill K.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: ZEROFILL