[RESOLVED] Export MySQL table from C++ Using OUTFILE command

[saraswathisrinath]

Hi,

i like to export Mysql table as a csv file. The below command working good in MySQL command prompt and file stored in D drive.

SELECT * FROM LOG INTO OUTFILE 'D:\\logreport.csv' FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\r\n";

I like to use this command via C++.

CString sQuery = "SELECT * FROM log INTO OUTFILE 'D:\\logreport.csv' FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\r\n"";

Getting missing closing quote Error. So tried like below,

sQuery = "SELECT * FROM log INTO OUTFILE 'D:\\logreport.csv'";
DB.ExecuteSQL(QueryStr);
DB.ExecuteSQL(FlushStr);

This query also not working. showing empty error message.

[2kaud]

Try

CString sQuery = "SELECT * FROM log INTO OUTFILE 'D:\\logreport.csv' FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY \"\r\n\"";

ie escape the " so the compiler treats it as an embedded " and not a terminating " of the previous ".

[saraswathisrinath]

Try

CString sQuery = "SELECT * FROM log INTO OUTFILE 'D:\\logreport.csv' FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY \"\r\n\"";

ie escape the " so the compiler treats it as an embedded " and not a terminating " of the previous ".

Thank you. Working Good.

sQuery = "SELECT * FROM log INTO OUTFILE 'D:\\logreport.csv'";
DB.ExecuteSQL(QueryStr);
DB.ExecuteSQL(FlushStr);

This query also not working. showing empty error message.

Sorry. Problem find out in the above case. careless mistake from my side. QueryStr passed ExecuteSQL , but stored quesry in sQuery

Thank you once again.