Tinyint will only go up to 127 when it is signed. Try INT.
Also, please read the Docs section about data types and their sizes. It will
save you more embarassing questions like these. :)
j----- k-----
On Tuesday 24 April 2001 20:39, Howard Picken wrote:
> -----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
--
Joshua Kugler
Associated Students of the University of Alaska Fairbanks
Information Services Director
[EMAIL PROTECTED]
907-474-7601
---------------------------------------------------------------------
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
