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;