Re: Simple query question

"Reshat Sabiq" <sabiq@purdue.edu> writes:
> I believe Oracle requires singles for values too. That must be a
> standard.

It is.  SQL92 contains

         <double quote> ::= "

         <quote> ::= '

         <delimited identifier> ::=
              <double quote> <delimited identifier body> <double quote>

         <character string literal> ::=
              [ <introducer><character set specification> ]
              <quote> [ <character representation>... ] <quote>
                [ { <separator>... <quote> [ <character representation>... ] <quote> }... ]

I can't believe that MySQL gets such a basic element of SQL syntax wrong
--- perhaps the OP is mistaken?  If MySQL really does treat doublequote
as introducing a literal, how do they handle weird identifiers, like
names with embedded spaces?

            regards, tom lane