RE: [PHP-DB] Enlarging tables
| From: | Hutchins, Richard | Date: | Mon, 09 Dec 2002 14:56:27 +0000 |
| Subject: | RE: [PHP-DB] Enlarging tables | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-23941@lists.php.net to get a copy of this message | ||
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
>