I could be much clearer:
I understand the backtick character, when used on either side of a string i.e. `Hello there` will allow the string to be accessed as one unit, even though there is a space in it. Also, it will allow for `Hello-there` to be accessed as one unit. What I am wondering is, will the backtick allow for all of the other non-alphanumeric characters such as `Hello>there` and `Hello/there` and `Hello*there` to be accessed as one unit. Or will some of these characters cause an error? I can't find a solid answer on-line or in the manual.
Sorry for the ambiguity. Thanks,
John
I don't see what this has to do with variables, which you referred to in the original message (below). Also, it's still unclear what is the context in which you want to use backticks.
I'm going to guess that what you're asking about is how to quote identifiers in SQL statements. If that's the case, then you want to read the section in the MySQL manual that discusses legal identifiers:
http://dev.mysql.com/doc/mysql/en/Legal_names.html
If that's not what you're asking about, my apologies.
on 4/21/04 6:46 PM, Paul DuBois at [EMAIL PROTECTED] wrote:
At 13:38 -0700 4/21/04, John Mistler wrote:When issuing commands through the terminal (in Mac OS 10.3) to MySQL, I understand that if you surround a variable with "\\`" it will allow for characters such as - and space. Will it also allow for all other non-alphanumeric characters such as / and * and >, etc.?
I am confused by this message. For example:
The Mac OS X Terminal program doesn't speak to MySQL. MySQL client programs speak to the MySQL server.
What kind of variable are you referring to?
What does it mean to surround a variable with "\\`"?
What do you mean by "allow for characters such as - and space"? The variable will allow for - and space?
Maybe you could be more specific about what it is that you're trying to accomplish.
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]