Re: Simple query question

"Reshat Sabiq" <sabiq@xxxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly