Valid SQL?

Diez B. Roggisch deets at nospam.web.de
Tue May 23 13:36:10 CEST 2006


Harlin Seritt wrote:

> I have this string that I am sending via a Cursor.execute() using
> MySQLdb:
> 
> insert into table Ping82_eb13__elearn__ihost__com (`dateTime`,
> `values`) values(
> "Fri May 12 11:39:02 2006", "1")
> 
> Does anyone see anything wrong with this SQL syntax?

How about a stacktrace? 

http://www.catb.org/~esr/faqs/smart-questions.html

And you should use the parametrized version of execute, because then the
DB-API will take care of escaping the strings properly for you. Which is
the problem here, btw: you are using "" for strings, where SQl requires ''.

Diez



More information about the Python-list mailing list