Single and double quotes are usually string identifiers (double quoted strings can sometimes also refer to database objects) Backticks (backquotes) always refer to database objects (columns, tables, indexes, databases, etc.). Here is the page in the manual that explains it all.
http://dev.mysql.com/doc/mysql/en/Legal_names.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine "leegold" <[EMAIL PROTECTED]> wrote on 09/09/2004 02:00:32 PM: > 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. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
