RE: Max 127 records

[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', 'sfg', 'sg');
>
> MySQL returnerede:
>
> Duplicate entry '127' for key 1

This happens when the key is defined as a tinyint, a single byte datatype.
Change the column to a smallint (2 bytes), mediumint (3 bytes) or int (4
bytes):

ALTER TABLE kontakt MODIFY id INT UNSIGNED NOT NULL;

<URL: http://www.mysql.com/doc/A/L/ALTER_TABLE.html >

--
Roger


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php