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

 

mysql> SELECT desc,status,play_time,push_type, interval FROM cms_push;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 700
Current database: xxx_cms

ERROR 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;

mysql数据库字段命名与关键字冲突之坑,布布扣,bubuko.com

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

上一篇:细说MySQL备份的基本原理(系列一 ) 备份与锁


下一篇:《SQL Server 2012 Tutorials - Analysis Services Multidimensional Modeling》读后感