List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:August 13 2004 8:41am
Subject:Re: quoting keywords
View as plain text  
Hi,

> Hopefully a simple problem!? ...
>
> MySQL produces a server-error when performing a query like
>
> SELECT char FROM mytable WHERE id=4711
>
> This seems to be 'char' is a MySQL-keyword. Ok!
> But how can i quote it??? (I could not find any information about this
> issue in the documentation...)

Using "backticks" should work:

select `char` from mytable

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

Thread
quoting keywordsGuenter.Buehrle13 Aug
  • Re: quoting keywordsMartijn Tonies13 Aug