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
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
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
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
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
--
_/
, 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
: 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
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,
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
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
10 matches
Mail list logo