单引号字符 [英] character for single quote

问题描述

（反引号）和’是两个不同的单引号字符。我有一个显示前两个引号字符的mysql脚本，如果将它们更改为'，则会破坏语法。

如何从键盘上键入`

(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?

推荐答案

您所指的字符通常称为反引号（`）。它不是单引号，尽管在某些字体中它看起来像单引号。在MySQL中，它与单引号的含义完全不同，因为它用于转义表和列名，而单引号用于包围数据值。

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.

它很可能位于键盘的左上方，通常位于 1 键的左侧（正如Dav指出的那样，在美国键盘布局上，它是键盘的非移位版本）波浪号（〜）键）。

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).

这篇关于单引号字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！