http://www.mysql.com/doc/N/u/Numeric_types.html
20 is the display width: 'for a column declared as INT(5) ZEROFILL, a value of 4 is retrieved as 00004' Regards Dan > -----Original Message----- > From: John D. Kirkpatrick [mailto:[EMAIL PROTECTED]] > Sent: Friday, 15 February 2002 12:27 p.m. > To: [EMAIL PROTECTED] > Subject: Re: data type bigint(20) > > > MySQL Gurus, > > I'm trying to figure out what the number after the type means for numbers. > I noticed in someone's code that for the ID field they used bigint(20). > bigint I thought was fixed at 8 bytes. Does this override the size? 20 > bytes??? 20 bits? > > Thanks > John > > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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