On Sep 18, 5:20 am, Konstantinos Pachopoulos <[EMAIL PROTECTED]>
wrote:
> Hi,
> i am trying to execute the following query on a DB:
> qe.execQuery(r"SELECT * FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY
> '"' LINES TERMINATED BY '\n' FROM Commiter")
>
> However, whether i put the r in the front or not, i always get an error
> about the "\n".
> What's wrong?

Try

r"SELECT * FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES
TERMINATED BY '\n' FROM Commiter"

It works for me.


-- 
http://mail.python.org/mailman/listinfo/python-list

Reply via email to