Can't use column name "desc" in mysql

Question

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

You must use backticks `` around the desc word ` desc ` (skip the spaces in the start and the end though) — John Svensson, Nov 20 '11 at 07:56

score 17 · Accepted Answer · answered Nov 20 '11 at 07:55

17

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 (``)

answered Nov 20 '11 at 07:55

Shakti Singh

84,385
21
134
153

score 4 · Answer 2 · answered Nov 20 '11 at 07:55

The word desc is a reserved word and must be in backticks when used as a column name.

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

I'd also advise you not to use desc as a column name in future as it is confusing and will just cause problems. You could use description instead, for example.

score 3 · Answer 3 · answered Nov 20 '11 at 07:55

3

DESC is a reserved word of MySQL and if you use it for naming consider using `desc`.

answered Nov 20 '11 at 07:55

Nedret Recep

726
5
8

Can't use column name "desc" in mysql

3 Answers3

Linked

Related