-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 25 April 2001 2:31 PM
To: Howard Picken
Subject: Why MySQL db will only allow 127 records imported?
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
database,sql,query
If you just reply to this message, and include the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. You have written the following:
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
I'm importing an id field (incrementing from 1-900) which is the main index
(I've tried importing without it). If I delete the first 200 lines from the
import file. It won't import anything and I get the same error.
If I remove all data from the table then try again I get the same problem.
id is set to tinyint(5)
I'm stumped... anyone have any ideas?
Thanks
Howard
---------------------------------------------------------------------
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
