用"(`)"将有冲突的字段框起来,,键盘上1边上那个键。
例:
SELECT * FROM yun_roleright WHERE right LIKE '%{13}%';
上面sql语句中right字段名与关键字冲突,会报错,,,应改成下面:
SELECT * FROM yun_roleright WHERE `right` LIKE '%{13}%';
用"(`)"将有冲突的字段框起来,,键盘上1边上那个键。
例:
SELECT * FROM yun_roleright WHERE right LIKE '%{13}%';
上面sql语句中right字段名与关键字冲突,会报错,,,应改成下面:
SELECT * FROM yun_roleright WHERE `right` LIKE '%{13}%';