> 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. > > -- > Dan Nelson > [EMAIL PROTECTED] >
Backtics can also be useful to avoid SQL injections if an application your working on requires table names or field names to be supplied from user input (always a bad idea) like a select box. Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
