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`, `by`, `telefon`,
>`kommentar`) VALUES ('', 'fsd', 'sfdg', 'sg',
+'fdsg', 'sfg', 'sg');
>
> MySQL returnerede:
>
> Duplicate entry '127' for key 1
>
Your table has an auto_increment column of type 'tiny int'. This allows
values between -128 and 127. You should choose a different column type.
Regards,
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
---------------------------------------------------------------------
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
