[FAQ] You have an error in your SQL syntax; tidb 关键字保留

[yilong (yi888long)]

[问题澄清]

SELECT * FROM configuration config,label label ；
运行时出现
You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 34 near “config,label label ；

[原因分析]

label 是关键字

[解决方案]

使用反引号 `` 可以查询

[参考案例]

tidb 关键字查询问题

SELECT * FROM configuration config,label label ； 运行时出现 You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 34 near …