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

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

2001-06-15 Thread David Lidström ( Cabesa )
most probable is that the auto-inc field is of a type that will not allow higher values than 127!! What is the field-type? \d -Original Message- From: Mette Møller Madsen [mailto:[EMAIL PROTECTED]] Sent: den 15 juni 2001 13:46 To: mysql listserver Subject: Can only create 127

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

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 in a table I get this error: ERROR 1062

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

2001-06-15 Thread Rafal Jank
Mette Mller 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 -- _/

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

2001-06-15 Thread Pat Sherrill
, 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 auto incremented primary key) Does anyone know how to store _more_ than 127 rows

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 know how

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,

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

2001-06-15 Thread Dvoek 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==Original message

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

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