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'
-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
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: