On Jun 5, 2004, at 11:40 PM, David Blomstrom wrote:
Here are a few rows from the comma delimited file I
imported. Do you have a hunch what might be going on
here?
Thanks.
"gd","oat",239,,"Grenada","nat"
"gp","oat",240,,"Guadeloupe","dep"
"ht","oat",241,,"Haiti","nat"
"is","oat",242,,"Iceland","nat"
David Blomstrom wrote:
I just discovered that one of my MySQL tables is
incomplete. I created it by importing a comma
delimited file I had made from a spreadsheet, but it
appears as many as 3,000 rows or so were missing.
So I decided to give it another try. MySQL Front
refused to import it because
say FIELDS TERMINATED BY ',' FIELDS ENCLOSED
BY '"'
LINES TERMINATED BY '\n'
hth,
Martin
- Original Message -
From: "David Blomstrom" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 06, 2004 2:40 AM
Subject: Comma Delimite
I just discovered that one of my MySQL tables is
incomplete. I created it by importing a comma
delimited file I had made from a spreadsheet, but it
appears as many as 3,000 rows or so were missing.
So I decided to give it another try. MySQL Front
refused to import it because of some sort of error
