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

[Lukasz Szybalski]

On 8/7/07, Carsten Haese <carsten at uniqsys.com> wrote:
> 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`) ...
>
>>> conn=MySQLdb.connect( SERVER, USER, PASS, DB )
>>> c=conn.cursor()
>>> c.execute("insert into tablename('desc')Values('sss')")
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "c:\Python25\lib\site-packages\MySQLdb\cursors.py", line 166, in execute
    self.errorhandler(self, exc, value)
  File "c:\Python25\lib\site-packages\MySQLdb\connections.py", line 35, in defau
lterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax
; check the manual that corresponds to your MySQL server version for the right s
yntax to use near ''desc')Values('sss')' at line 1")


I was able to escape it on ODBC by doing 'DESC$' but that doesn't work for mysql