And since it's auto_increment, use something like int unsigned because you
don't need to store negative numbers...
Bill "Elvis" Gibbs
goEbusiness.com - putting e-motion in your business
email - [EMAIL PROTECTED] work - 301-668-5090 cell - 301-748-6938
-----Original Message-----
From: Bruce Stewart [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 15, 2001 8:35 AM
To: 'Mette Møller Madsen'; 'mysql listserver'
Subject: RE: Can only create 127 records in a table :o(
Change the datatype of your primary key from TINYINT to something larger,
like SMALLINT, MEDIUMINT, or INT.
-----Original Message-----
From: Mette Møller Madsen [mailto:[EMAIL PROTECTED]]
Sent: Fri, 15 June 2001 13:46
To: mysql listserver
Subject: Can only create 127 records in a table :o(
Hi there!
When I try to insert more than 127 rows/records in a table I get this error:
ERROR 1062: Duplicate entry '127' for key 1
(the key is an auto incremented primary key)
Does anyone know how to store _more_ than 127 rows in a table?
My guess is that I need to change to settings of my db, but I cannot find
anything in the manual. (I'm running version 3.23.38 which should be a
stable one.)
best regards,
Mette Madsen
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
