用"(`)"将有冲突的字段框起来,,键盘上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

05-21 01:25