In the last episode (Sep 09), Fagyal Csongor said:
> Dan Nelson wrote:
> >In the last episode (Sep 09), leegold said:
> >>Could anyone link me or explain the purposes of backquotes in an
> >>SQL statement. I tried searching the manual and googling it but
> >>couldn't find a simple explaination. ``` vs. "regular" single
> >>quotes'''. Thanks, Lee G.
> >Backquotes are used to delimit table or field names; they aren't
> >used to delimit SQL strings the way ' or " are. You'll almost never
> >need to use them unless you have spaces or other strange characters
> >in your table/field names.
> ...or when you chose a reserved MySQL keyword as a column name - for
> ...which might happen automatically when you upgrade to a new version of
> MySQL :-)) Your column name suddenly becoming a keyword is a _lot_
> ;-), fun so 'don't forget your backticks'.
I forgot about that case, which is probably why glue drivers like
MyODBC end up quoting everything.