Re: Can only create 127 records in a table :o(

2001-06-15 Thread Alexander Skwar
So sprach Mette Møller Madsen am Fri, Jun 15, 2001 at 01:46:06PM +0200: > 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) I suppose the auto_inc column is ju

RE: Can only create 127 records in a table :o(

2001-06-15 Thread Bill \"Elvis\" Gibbs
age- 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 SMAL

Fwd: Re: Re: Can only create 127 records in a table :o(

2001-06-15 Thread Dvořáček Michal
This is a forwarded message From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> To: Dvoøáèek Michal <[EMAIL PROTECTED]> Date: Friday, June 15, 2001, 1:24:16 PM Subject: Can only create 127 records in a table :o( get back, due post not cointains some key words: database ===8<===

Re: Can only create 127 records in a table :o(

2001-06-15 Thread Thomas Karcher
Hi, > 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

RE: Can only create 127 records in a table :o(

2001-06-15 Thread Jon Haworth
: 15 June 2001 12: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 k

Re: Can only create 127 records in a table :o(

2001-06-15 Thread Gerald Clark
How many positive integers do you expect a tinyint to hold? Change it to an int or greater, and your problem should disappear. You realize, though, that this is pure conjecture, since you did not supply any information. Mette Møller Madsen wrote: > Hi there! > > When I try to insert more than

Re: Can only create 127 records in a table :o(

2001-06-15 Thread Pat Sherrill
MAIL PROTECTED]> Sent: Friday, June 15, 2001 7:46 AM 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 aut

Re: Can only create 127 records in a table :o(

2001-06-15 Thread Rafal Jank
Mette Mřller Madsen wrote: > > 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) > Change type of your primary key column to something bigger than tinyint --

ODP: Can only create 127 records in a table :o(

2001-06-15 Thread Daniel Las
074 > -Oryginalna wiadomoœæ- > Od: Mette Møller Madsen [mailto:[EMAIL PROTECTED]] > Wys³ano: 15 czerwca 2001 13:46 > Do: mysql listserver > Temat: Can only create 127 records in a table :o( > > > Hi there! > > When I try to insert more than 127 rows/records

RE: Can only create 127 records in a table :o(

2001-06-15 Thread Bruce Stewart
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

RE: Can only create 127 records in a table :o(

2001-06-15 Thread David Lidström ( Cabesa )
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

Can only create 127 records in a table :o(

2001-06-15 Thread Mette Møller Madsen
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,