首页 > 代码库 > mysql数据库字段命名与关键字冲突之坑

mysql数据库字段命名与关键字冲突之坑

 

mysql> SELECT desc,status,play_time,push_type, interval FROM cms_push;ERROR 2006 (HY000): MySQL server has gone awayNo connection. Trying to reconnect...Connection id: 700Current database: xxx_cmsERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near desc,status,play_time,push_type, interval FROM cms_push at line 1

问题很简单,desc和interval是关键字,需要加上引号,以后起名要注意了

mysql> SELECT desc,status,play_time,push_type,interval FROM cms_push;