"Howard Picken" <[EMAIL PROTECTED]> wrote:
> I'm trying to import a csv file into a db.
> all text fields are " enclosed and all fields are , delimited.
> the file is 900 records long.
>
> The error I'm getting is..
>
> ERROR 1062 at line 1: Duplicate entry '127' for key 1
Your ID field is type 'TINYINT' which can contain a max value of 127.
Numbers larger than that are saved to the DB as 127 so it's choking b/c it's
causing duplicate values for a key field. Change the field type to INT or
something appropriate for your dataset. Make it UNSIGNED if you don't
expect negative numbers in the ID field.
SQL is your friend (added to please the filter).
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/
---------------------------------------------------------------------
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
