Re: Doubt about TINYINT type - Paul DuBois - com.mysql.lists.mysql

6 messages in com.mysql.lists.mysqlRe: Doubt about TINYINT type

From	Sent On	Attachments
Ronan Lucio	27 Apr 2004 07:53
Paul DuBois	27 Apr 2004 08:26
Ronan Lucio	27 Apr 2004 09:59
Keith C. Ivey	27 Apr 2004 10:28
Paul DuBois	27 Apr 2004 10:43
Don Read	28 Apr 2004 22:33

Subject:	Re: Doubt about TINYINT type
From:	Paul DuBois (pa...@mysql.com)
Date:	04/27/2004 10:43:19 AM
List:	com.mysql.lists.mysql

At 13:29 -0400 4/27/04, Keith C. Ivey wrote:

On 27 Apr 2004 at 13:59, Ronan Lucio wrote:

OK, I understood it, but I didn´t understand why is there an option TINYINT(n)

See http://dev.mysql.com/doc/mysql/en/Numeric_types.html

| Another extension is supported by MySQL for optionally | specifying the display width of an integer value in | parentheses following the base keyword for the type (for | example, INT(4)). This optional display width specification | is used to left-pad the display of values having a width | less than the width specified for the column. However, the | display width does not constrain the range of values that | can be stored in the column, or the number of digits that | will be displayed for values having a width exceeding that | specified for the column.

I haven't found much use for display widths myself, but then different people use MySQL differently.

I agree. I cannot think of a time when I've actually specified a display width, except just to see what effect it has on result display. :-)