RE: [PHP-DB] Enlarging tables

Premature clickage... Or you could use a mediumint or int. Just check the mysql manual and select the int type that suits the size of your db best. > -----Original Message----- > From: Hutchins, Richard [mailto:Richard.Hutchins@GetingeCastle.com] > Sent: Monday, December 09, 2002 9:56 AM > To: 'mike karthauser'; php-db@lists.php.net > Subject: RE: [PHP-DB] Enlarging tables > > > By definition a tinyint has a value from range -127 to 127. > Try using a > smallint instead. > > > -----Original Message----- > > From: mike karthauser [mailto:mikek@brightstorm.co.uk] > > Sent: Monday, December 09, 2002 9:56 AM > > To: php-db@lists.php.net > > Subject: Re: [PHP-DB] Enlarging tables > > > > > > on 9/12/02 2:50 pm, Aaron Wolski at aaronjw@martekbiz.com wrote: > > > > > What's your table structure looks like? > > > > > +------------+--------------+------+-----+---------+----------------+ > > | Field | Type | Null | Key | Default | Extra > | > > > +------------+--------------+------+-----+---------+----------------+ > > | id | tinyint(4) | | PRI | NULL | > auto_increment | > > | bookcode | varchar(20) | YES | | NULL | > | > > | coursecode | varchar(10) | YES | | NULL | > | > > | date | date | YES | | NULL | > | > > | title | varchar(255) | YES | | NULL | > | > > > +------------+--------------+------+-----+---------+----------------+ > > > > > > -- > > Mike Karthauser > > Managing Director - Brightstorm Ltd > > > > Email >> mikek@brightstorm.co.uk > > Web >> http://www.brightstorm.co.uk > > Tel >> 0117 9426653 (office) > > 07939 252144 (mobile) > > > > Snailmail >> Unit 8, 14 King Square, > > Bristol BS2 8JJ > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >