Re: Max 127 records

2002-04-19 Thread Richard Emery
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

Re: Max 127 records

2002-04-19 Thread Egor Egorov
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

RE: Max 127 records

2002-04-19 Thread Roger Baklund
* 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',

Re: Max 127 records

2002-04-19 Thread Ciprian Trofin
> 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

Re: Max 127 records

2002-04-19 Thread Steve Buehler
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

Re: Max 127 records

2002-04-19 Thread Fred van Engen
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`,