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

[Carsten Haese]

On Tue, 2007-08-07 at 11:58 -0500, Lukasz Szybalski wrote:
> 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'?

insert into tablename(id,`desc`) ...

HTH,

-- 
Carsten Haese
http://informixdb.sourceforge.net