MySQL: What is the practical use of ZEROFILL in your case?

  • khazretsapenov / 206 / Thurs, 18 Feb 2010 14:02:00 GMT / Comments (3)
  • Hi,What is the practical use of ZEROFILL in your case?regards,Khaz
  • Keywords:

    practical, zerofill, case, mysql

  • http://database.itags.org/mysql/62216/«« Last Thread - Next Thread »»

    1. 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:
      http://groups-beta.google.com/group...090b6cac8da980/

      Regards,
      Bill K.

      billkarwin | Sun, 30 Dec 2007 22:16:00 GMT |

    2. 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...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:
      http://groups-beta.google.com/group...090b6cac8da980/
      > Regards,
      > Bill K.

      khazretsapenov | Sun, 30 Dec 2007 22:17:00 GMT |

    3. 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.

      billkarwin | Sun, 30 Dec 2007 22:18:00 GMT |

  • MySQL Questions

    • Your message to MySQL AB (ID#863700)

      Dear Sirs,This is my 3rd time I am writing to you.May be there is a problem!We want to buy some MySQ...

      By georgevanev, 2 Comments

    • zabbix mysql problem

      I am trying to install zabbix, and at the third step I get this error:[root@localhost etc]# mysql -u...

      By sizonsibande, 2 Comments

    • YAQQ (Yet Another Query Question)

      I am using mysql 4.0.x on a Linux machine with a JSP/Servlet front-end todisplay the data.I have a t...

      By mark_phillips, 7 Comments

    • Yen?

      I just installed MySQL v5.0 on 'Windows XP and when I tried to open thehelp, it told me I had t...

      By cnelson, 1 Comments

    • yum version 5.*

      I am using Red Hat Fedora Core 4 and I wanted to yum mysql version 5of any other and find with Core ...

      By karllarsen, 2 Comments