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
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
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<===
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
: 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
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
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
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
--
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
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
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
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,
12 matches
Mail list logo