Re: quoting keywords

[Martijn Tonies]

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