mysql 字段名和关键字冲突

用"(`)"将有冲突的字段框起来,,键盘上1边上那个键。

例:

SELECT * FROM yun_roleright WHERE right LIKE '%{13}%';

上面sql语句中right字段名与关键字冲突,会报错,,,应改成下面:

SELECT * FROM yun_roleright WHERE `right` LIKE '%{13}%';
原文地址:https://blog.csdn.net/qq_42176520/article/details/81168578
原文地址:https://www.cnblogs.com/jpfss/p/11121074.html