Bug #55221 Error: MySQL Connector/C can't process this kind of statement
Submitted: 13 Jul 2010 16:30 Modified: 13 Jul 2010 17:49
Reporter: Tim Bridges Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.25 OS:Windows (Windows 7 64 bit)
Assigned to: CPU Architecture:Any

[13 Jul 2010 16:30] Tim Bridges 
Description:
I recently upgraded workbench to 5.2.25 CE and now I'm having issues loading files. I'm using the following command: 
LOAD DATA INFILE 'C:/pro/inventory.csv' 
INTO TABLE production 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"' 
LINES TERMINATED BY '\n' 
IGNORE 3 LINES; 

And receiving the following error: 
Error: MySQL Connector/C can't process this kind of statement 

In my previous version of workbench 5.2.22 it worked fine.

How to repeat:
Issue the command below within Workbench:

LOAD DATA INFILE 'C:/pro/inventory.csv' 
INTO TABLE production 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"' 
LINES TERMINATED BY '\n' 
IGNORE 3 LINES;
[13 Jul 2010 17:49] Valeriy Kravchuk 
This is a duplicate of bug #49694. Error message you get is a temporary workaround for the crash in several previous versions.
[3 May 2012 10:12] siza sotondoshe 
Cass

Attachment: test2.csv (application/vnd.ms-excel, text), 49 bytes.