From: Jamis Buck <jgb3@...>
Date: 2004-10-06T04:00:52+09:00
Subject: Re: Rubyonrails - SQL change request

Thomas Fini Hansen wrote:

> No the right solution would be to quote the column names:
> 
>     UPDATE
>       `group` = 'test'
>     WHEN `id`='1'
> 
> That ` is annoying on keyboards with dead keys though.
> 

Seems to me the "standard" (as if there were really a reliable SQL 
standard) is to double quote column and table names (if quoting is 
needed), and single quote string literals:

   UPDATE the_table
      SET "group" = 'test'
    WHEN id=1

- Jamis

-- 
Jamis Buck
jgb3@email.byu.edu
http://www.jamisbuck.org/jamis