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'.
- Cs.
