Are you saying that you want a table with a maximum of 127 records ? Or,
that due to your TINYINT, you are RESTRICTED to 127 records?
If you are restricted to records, change TINYINT to INT.
If you want to have ONLY 128 records, change TINYINT to TINYINT UNSIGNED,
which will permit records 1 thro
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`,