Can you post the output of SHOW CREATE TABLE for the table you are having
difficulty inserting into? Without knowing the table structure its very
difficult to work out why your data load is failing.
MySQL & Cognos Contractor
Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer (CMDEV)
IBM Cognos BI Developer
Telephone +44 (0)7812 451238
From: Patrice Olivier-Wilson [mailto:biz@stripped]
Sent: 27 September 2009 15:19
Subject: Re: Newbie question: importing cvs settings
Back again... I have 192 records to import, and tried my extra line at
the end hoping for a work around, but nope, it failed at line 17 again.
Invalid field count in CSV input on line 17.
Anyone have an idea why this might be happening?
Patrice Olivier-Wilson wrote:
> Yep, typo ...:-(
> I did some screen shots of 2 tests. A workaround solution is to make a
> final entry in the csv file that I don't really need. Then everything
> up to that point gets imported ok using CSV method. The LOAD DATA
> method did not enter anything.
> My earlier assumption about line 17 was false. It was dependent on how
> many rows, and I had been using tests with same amount of data.
> As I said, very beginner level, so thanks for the patience.
> screenshots at
> thank you....
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.409 / Virus Database: 270.13.113/2396 - Release Date: 09/26/09