On Mon, 23 Dec 2002 13:01:58 -0500, Tom Lane <tgl@sss.pgh.pa.us>
wrote:
> <double quote> ::= "
> <quote> ::= '
>
>I can't believe that MySQL gets such a basic element of SQL syntax wrong
s/My/MS/ and better believe it :-) I did this in 7.0:
CREATE TABLE tst2 (id INT, x varchar(20))
INSERT INTO tst2 VALUES (1, "one")
INSERT INTO tst2 VALUES (2, 'two')
SELECT * FROM tst2
id x
----------- --------------------
1 one
2 two
This seems to be a common misconception among database vendors who
consider themselves leading in one sense or another.
Servus
Manfred