SQL Query Error message

Question

I have this SQL Query

   CREATE TABLE items(
   partnum VARCHAR( 20 ) NOT NULL ,
   DESC VARCHAR( 50 ) NOT NULL ,
   price INT( 11 ) NOT NULL ,
   src VARCHAR( 25 ) NOT NULL ,
   PRIMARY KEY (  `partnum` )
   );

It's meant to create a table in my database but I keep receiving the following error:

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 varchar(50) NOT NULL,
 price int(11) NOT NULL,
 src varchar(25) NOT NULL,
 ' at line 3

Any idea what i'm doing wrong?

Desc is a reserved word (as in `order by foo desc`) and needs to be in back ticks. — Martin Smith, Apr 14 '13 at 11:49
Doh, how did I miss that! @MartinSmith wasn't a duplicate but thanks — user182, Apr 14 '13 at 11:56

apomene · Accepted Answer · 2013-04-14T11:59:19.050

0

Desc is a reserved keyword it cant used as a name of column, put it in quotes

or rename it to e.g Description

edited Apr 14 '13 at 11:59

answered Apr 14 '13 at 11:49

apomene

14,282
9
46
72

putting a keyword in quotes isn't going to solve the problem – Ejaz Apr 14 '13 at 12:03
@Ejay I believe it is. HAve you tried it and it fails? – apomene Apr 14 '13 at 12:07
yes I've tried it. I think you're mixing up _backticks_ and _quotes_ :) – Ejaz Apr 14 '13 at 12:09

SQL Query Error message

1 Answers1