[DB-SIG] How to escape special field name, mysql?

Lukasz Szybalski szybalski at gmail.com
Tue Aug 7 18:58:38 CEST 2007


Hello,
I have installed mysqldb python bindings and I am using python to
write to mysql.

I have a field called "Desc" in a database (short for description )
But this name is used by mysql for sorting DESC

When i do:
insert into tablename(id,desc)VALUES(1,'some text')

How do I escape 'desc'? Or maybe I do something else?

Lucas


More information about the DB-SIG mailing list