List:General Discussion« Previous MessageNext Message »
From:John Date:September 27 2009 3:18pm
Subject:RE: Newbie question: importing cvs settings
View as plain text  
Patrice,

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.

Regards

John Daisley
MySQL & Cognos Contractor

Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer (CMDEV)
IBM Cognos BI Developer

Telephone +44 (0)7812 451238
Email john@stripped


-----Original Message-----
From: Patrice Olivier-Wilson [mailto:biz@stripped] 
Sent: 27 September 2009 15:19
Cc: 'mysql'
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
> http://biz-comm.com/mysqlprojects/
>
> thank you....
>
>>
>>  
>
>


-- 
Patrice Olivier-Wilson
888-385-7217
http://biz-comm.com


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1

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
05:51:00

Thread
Newbie question: importing cvs settingsPatrice Olivier-Wilson26 Sep
  • RE: Newbie question: importing cvs settingsJohn26 Sep
    • Re: Newbie question: importing cvs settingsPatrice Olivier-Wilson26 Sep
      • Re: Newbie question: importing cvs settingsPatrice Olivier-Wilson27 Sep
        • RE: Newbie question: importing cvs settingsJohn27 Sep
        • RE: Newbie question: importing cvs settingsJerry Schwartz29 Sep
          • Re: Newbie question: importing cvs settingsPatrice Olivier-Wilson29 Sep
            • Re: Newbie question: importing cvs settings - followupPatrice Olivier-Wilson30 Sep
      • RE: Newbie question: importing cvs settingsGavin Towey28 Sep