mysql 字段名包含反引号

Question

我想创建一个带有反引号包围的字段的表格

CREATE TABLE t1 (`id` INT);

我已经尝试过:

CREATE TABLE t1 (``id`` INT);

但是没有成功。

Answer 1

它位于 documentation (强调我的):

Identifier quote characters can be included within an identifier if you quote the identifier. If the character to be included within the identifier is the same as that used to quote the identifier itself, then you need to double the character.

就您而言:

CREATE TABLE t1 (```id``` INT);