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
> example.
>
> ...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.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
