Valid SQL?

Diez B. Roggisch deets at
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?

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 ''.


More information about the Python-list mailing list