Hey - can anyone help?
I have a MySql-db in which I can only have 127 records.
Using phpmyadmin to insert record number 128 (autoincrement) gets this message:
INSERT INTO `kontakt` (`id`, `navn`, `adresse`, `postnummer`, `by`, `telefon`,
`kommentar`) VALUES ('', 'fsd', 'sfdg', 'sg', 'fdsg',
Fra: Henning Olsen [mailto:[EMAIL PROTECTED]]
Sendt: 19. april 2002 14:39
Hey - can anyone help?
I have a MySql-db in which I can only have 127 records.
Using phpmyadmin to insert record number 128 (autoincrement) gets
this message:
INSERT INTO `kontakt` (`id`, `navn`, `adresse`,
Hi,
On Fri, Apr 19, 2002 at 01:38:49PM +0100, Henning Olsen wrote:
Hey - can anyone help?
I have a MySql-db in which I can only have 127 records.
Using phpmyadmin to insert record number 128 (autoincrement) gets this message:
INSERT INTO `kontakt` (`id`, `navn`, `adresse`, `postnummer`,
WowI think I can finally help somebody on this list.
Ok. I bet that you have your column set up as tinyint. I presume it
would be the id column that you have. tinyint is the following:
Signed values: -128 to 127
Unsigned values: 0 to 255
I ran into the problem before too. So if you want
A closed mouth maintains a happy mind.
It could be that you specified signed TINYINT as type for the PRIMARY
KEY. Signed TINYINT goes from -127 to 127, hence your problem.
HO INSERT INTO `kontakt` (`id`, `navn`, `adresse`, `postnummer`, `by`,
HO `telefon`, `kommentar`) VALUES ('',
* Henning Olsen
I have a MySql-db in which I can only have 127 records.
Using phpmyadmin to insert record number 128 (autoincrement) gets
this message:
INSERT INTO `kontakt` (`id`, `navn`, `adresse`, `postnummer`,
`by`, `telefon`, `kommentar`) VALUES ('', 'fsd', 'sfdg', 'sg',
'fdsg',
Henning,
Friday, April 19, 2002, 3:38:49 PM, you wrote:
HO Hey - can anyone help?
HO I have a MySql-db in which I can only have 127 records.
HO Using phpmyadmin to insert record number 128 (autoincrement) gets this message:
HO INSERT INTO `kontakt` (`id`, `navn`, `adresse`, `postnummer`, `by`,
through 255.
FYI: show us your table structure next time; please don't force us to guess
your structure
- Original Message -
From: Henning Olsen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 19, 2002 7:38 AM
Subject: Max 127 records
Hey - can anyone help?
I have a MySql-db