(backtick) and ' are two different characters for single quote. I have a mysql script that shows the former two quote characters, if I change them to ', it breaks the syntax.
how do I type ` from the keyboard?
Asked
Active
Viewed 966 times
0
Ed S.
- 122,712
- 22
- 185
- 265
user121196
- 30,032
- 57
- 148
- 198
1 Answers
4
You are referring to the character commonly called a "backtick" (`). It is not a single quote, although in some fonts it can look like one. It has a completely different meaning in MySQL than a single quote, as it is used to escape table and column names, whereas the single quote is used to enclose data values.
It is at the top-left of your keyboard in all likelihood, often just to the left of the 1 key (as Dav pointed out below, on US keyboard layouts, it's the non-shift version of the tilde (~) key).
zombat
- 92,731
- 24
- 156
- 164
-
1On U.S. keyboards, it's the non-shift version of the `~` key. – Amber Aug 13 '09 at 23:09