I have a rhetorical question.

I'm learning as much as I can about MySQL.  There is one little detail 
that I don't *have* to know the answer to, but I'm curious about.  Don't 
waste your time replying if you're busy.

It appears that the display width is an option for certain types of 
numeric columns.  For instance, "SMALLINT(3) UNSIGNED" which would be a 
"number from 0 to 65535 with a display size of 3 characters in width, 
unless the value was greater than 3 characters in width, in which case 
all of the characters would be displayed."

What is the point of specifying a width?  I only see it being useful in 
combination with the ZEROFILL attribute, which would add leading zeros 
up to the display width if the number is fewer characters than the 
display width.  Otherwise, it seems to serve little purpose.

Would anyone mind shedding some light on this?

Thank you,
Erik


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to