Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
> 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?
back-ticks...
SELECT * FROM `table name with spaces` WHERE `key`="a";
MySQL = My personal interpretation of SQL...
;-)
Regards,
Michael Paesold
---------------------------(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
|