mysql資料庫欄位命名與關鍵字衝突之坑

標籤：des   style   blog   color   資料   io   for   re   

 

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;