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?
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
* 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',
> 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 ('', 'fs
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
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`,
> 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`,
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', 'sfg
