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

2007-08-07 Thread Lukasz Szybalski
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 m

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

2007-08-07 Thread 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: > inse

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

2007-08-07 Thread Lukasz Szybalski
On 8/7/07, Carsten Haese <[EMAIL PROTECTED]> 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 t

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

2007-08-07 Thread Carsten Haese
On Tue, 2007-08-07 at 13:06 -0500, Lukasz Szybalski wrote: > On 8/7/07, Carsten Haese <[EMAIL PROTECTED]> 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 ha

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

2007-08-07 Thread Lukasz Szybalski
On 8/7/07, Carsten Haese <[EMAIL PROTECTED]> wrote: > On Tue, 2007-08-07 at 13:06 -0500, Lukasz Szybalski wrote: > > On 8/7/07, Carsten Haese <[EMAIL PROTECTED]> wrote: > > > On Tue, 2007-08-07 at 11:58 -0500, Lukasz Szybalski wrote: > > > > Hello, > > > > I have installed mysqldb python bindings a

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

2007-08-07 Thread Paul Boddie
On Tuesday 07 August 2007 19:17, Carsten Haese wrote: > On Tue, 2007-08-07 at 11:58 -0500, Lukasz Szybalski wrote: > > > > When i do: > > insert into tablename(id,desc)VALUES(1,'some text') > > > > How do I escape 'desc'? > > insert into tablename(id,`desc`) ... Obviously MySQL supports the above,

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

2007-08-07 Thread Carsten Haese
On Wed, 2007-08-08 at 00:40 +0200, Paul Boddie wrote: > On Tuesday 07 August 2007 19:17, Carsten Haese wrote: > > On Tue, 2007-08-07 at 11:58 -0500, Lukasz Szybalski wrote: > > > > > > When i do: > > > insert into tablename(id,desc)VALUES(1,'some text') > > > > > > How do I escape 'desc'? > > > > i

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

2007-08-07 Thread Carsten Haese
On Tue, 2007-08-07 at 21:37 -0400, Carsten Haese wrote: > [...] The standard way (at least as far as > Informix understands it) is not to quote table/column names at all and > let the parser worry about determining whether the word it's looking at > is the name of a thing or a keyword. And worry it

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

2007-08-07 Thread Andy Todd
Lukasz Szybalski wrote: > On 8/7/07, Carsten Haese <[EMAIL PROTECTED]> wrote: >> On Tue, 2007-08-07 at 13:06 -0500, Lukasz Szybalski wrote: >>> On 8/7/07, Carsten Haese <[EMAIL PROTECTED]> wrote: On Tue, 2007-08-07 at 11:58 -0500, Lukasz Szybalski wrote: > Hello, > I have installed mys

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

2007-08-07 Thread Paul DuBois
Andy Todd wrote: > Lukasz Szybalski wrote: >> On 8/7/07, Carsten Haese <[EMAIL PROTECTED]> wrote: >>> On Tue, 2007-08-07 at 13:06 -0500, Lukasz Szybalski wrote: On 8/7/07, Carsten Haese <[EMAIL PROTECTED]> wrote: > On Tue, 2007-08-07 at 11:58 -0500, Lukasz Szybalski wrote: >> Hello, >>