MySQLdb & _mysql
mathieu.rohon at bull.net
Wed Mar 26 10:34:20 CET 2003
> The bug is not in the MySQL stuff but in the second line of your code...
> You should try (merge following in 1 line) ...
> c.execute("""LOAD DATA INFILE %s INTO TABLE table FIELD TERMINATED BY "\t"
> """ % s)
> Tip : always "print" the python generated SQL statements that raise MySQL
> exceptions. This (generally) shows the SQL error like yours.
thanks for your answer Gilles.
it works with your syntax. I didn't think to try the python syntax to
insert a python variable in a string, I though that the SQL query
wasn't a string like others.
but in fact it is.
I hope I won't have to post any question...
More information about the Python-list