QSqlQuery does not execute

[weixj2003ld]

I want to insert many records into MySQL,so I do as followings:

...
QSqlQuery mQuery;
if(!mQuery.exec("LOAD DATA INFILE '"+fileName+"' INTO TABLE table1 FIELDS  TERMINATED BY ' ' LINES TERMINATED BY '\r\n'"))
{
   QMessageBox::warning(0,"",mQuery.lastError().text());
   return false;
}
...

...
QSqlQuery mQuery;
if(!mQuery.exec("LOAD DATA INFILE '"+fileName+"' INTO TABLE table1 FIELDS  TERMINATED BY ' ' LINES TERMINATED BY '\r\n'"))
{
   QMessageBox::warning(0,"",mQuery.lastError().text());
   return false;
}
...

To copy to clipboard, switch view to plain text mode 

and there is no respones,that is, table1 has no recorders and there is no error.

But when I execute " LOAD DATA INFILE '"+fileName+"' INTO TABLE table1 FIELDS TERMINATED BY ' ' LINES TERMINATED BY '\r\n'" " in cmd window,it is ok,why?

[chenz]

You could look at mQuery.executedQuery() to see if the the query executed by QSqlQuery really matches the one you enter in the command window.

It could also be a transaction problem, maybe there is a COMMIT missing in your Qt code?

[weixj2003ld]

You could look at mQuery.executedQuery() to see if the the query executed by QSqlQuery really matches the one you enter in the command window.

I print the 'executedQuery()',and find that it execute ""LOAD DATA INFILE '"+fileName+"' INTO TABLE table1 FIELDS TERMINATED BY ' ' LINES TERMINATED BY '\r\n'"))" ,that is, it exectue the query as I type.

It could also be a transaction problem, maybe there is a COMMIT missing in your Qt code?

I have no transaction ,so there is no COMMIT.

By the way, if I exectue 'Insert' or 'update',it is ok.

[wysota]

Does exec() return true or false? What does QSqlQuery::lastError() return?

[weixj2003ld]

return true;

[wysota]

Then the query was executed successfully and there is nothing more you can do from within your application.

[Lesiok]

Problem with incorrect file path ?

[Lykurg]

...beside escaping your string proper. I bet it must be

mQuery.exec("LOAD DATA INFILE '"+fileName+"' INTO TABLE table1 FIELDS  TERMINATED BY ' ' LINES TERMINATED BY '\\r\\n'")

mQuery.exec("LOAD DATA INFILE '"+fileName+"' INTO TABLE table1 FIELDS  TERMINATED BY ' ' LINES TERMINATED BY '\\r\\n'")

To copy to clipboard, switch view to plain text mode 

Also have a look at bindValue or QString::arg() which makes your code better readable.