desc mysql 用不了_不能使用列名“ desc”在MySQL中

INSERT INTO movie (id, title, desc, released, views, featured) VALUES ('', 'title', '

\r\n description

\r\n', '2006-12-12', '0', '0')

error is

1064 - 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, released, views, featured) VALUES ('', 'title', '

\r\n description \r\n', ' at line 1

table structure is

id [ (pk, auto_inc) int(11) ]

title [ varchar(256) ]

desc [ text ]

released [ date ]

views [ int(11) ]

featured [ int(11) ]

running in phpmyadmin sql editor

解决方案

desc is a mysql reserved word. you must use backticks `` with the columns which are reserved words.

INSERT INTO movie (id, title, `desc`, released, views, featured)...

You should avoid using reserved words as column name or must use backticks (``)