[PHP-DB] Enlarging tables
We have been entering data into a mysql table and it has got to id=127 and then stopped us from entering anymore data. When i built the table i must have specified the size wrong. Can anyone recommend how to fix this? regards mikek -- Mike Karthauser Managing Director - Brightstorm Ltd Email[EMAIL PROTECTED] Web http://www.brightstorm.co.uk Tel 0117 9426653 (office) 07939 252144 (mobile) SnailmailUnit 8, 14 King Square, Bristol BS2 8JJ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Enlarging tables
What's your table structure looks like? Aaron -Original Message- From: mike karthauser [mailto:[EMAIL PROTECTED]] Sent: December 9, 2002 9:48 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Enlarging tables We have been entering data into a mysql table and it has got to id=127 and then stopped us from entering anymore data. When i built the table i must have specified the size wrong. Can anyone recommend how to fix this? regards mikek -- Mike Karthauser Managing Director - Brightstorm Ltd Email[EMAIL PROTECTED] Web http://www.brightstorm.co.uk Tel 0117 9426653 (office) 07939 252144 (mobile) SnailmailUnit 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
RE: [PHP-DB] Enlarging tables
http://www.mysql.com and check 'alter table' with this you can fix it but using phpmyadmin or another program is more handy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Enlarging tables
What kind of table? Can you provide your table creation script or the output of mysqldescribe tablename; -Original Message- From: mike karthauser [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 9:48 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Enlarging tables We have been entering data into a mysql table and it has got to id=127 and then stopped us from entering anymore data. When i built the table i must have specified the size wrong. Can anyone recommend how to fix this? regards mikek -- Mike Karthauser Managing Director - Brightstorm Ltd Email[EMAIL PROTECTED] Web http://www.brightstorm.co.uk Tel 0117 9426653 (office) 07939 252144 (mobile) SnailmailUnit 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
Re: [PHP-DB] Enlarging tables
on 9/12/02 2:50 pm, Aaron Wolski at [EMAIL PROTECTED] 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[EMAIL PROTECTED] Web http://www.brightstorm.co.uk Tel 0117 9426653 (office) 07939 252144 (mobile) SnailmailUnit 8, 14 King Square, Bristol BS2 8JJ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 9:56 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Enlarging tables on 9/12/02 2:50 pm, Aaron Wolski at [EMAIL PROTECTED] 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[EMAIL PROTECTED] Web http://www.brightstorm.co.uk Tel 0117 9426653 (office) 07939 252144 (mobile) SnailmailUnit 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
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:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 9:56 AM To: 'mike karthauser'; [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 9:56 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Enlarging tables on 9/12/02 2:50 pm, Aaron Wolski at [EMAIL PROTECTED] 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[EMAIL PROTECTED] Web http://www.brightstorm.co.uk Tel 0117 9426653 (office) 07939 252144 (mobile) SnailmailUnit 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Enlarging tables
on 9/12/02 2:58 pm, Hutchins, Richard at [EMAIL PROTECTED] wrote: 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. Ta. Thats working now. Thanks from a 3 week old newbie. -- Mike Karthauser Managing Director - Brightstorm Ltd Email[EMAIL PROTECTED] Web http://www.brightstorm.co.uk Tel 0117 9426653 (office) 07939 252144 (mobile) SnailmailUnit 8, 14 King Square, Bristol BS2 8JJ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
