Re: Error in creating table

[Shantanu Oak]

since desc is a reserved word, use any other name or use backticks like this...

CREATE TABLE new_jobs
(
ID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(ID),
`desc` VARCHAR(60),
refno VARCHAR(15),
field VARCHAR(30),
qual VARCHAR(30),
exp VARCHAR(20),
locate VARCHAR(20),
posted VARCHAR(10),
type VARCHAR(10),
detail VARCHAR(1000),
keyword VARCHAR(500),
addinfo VARCHAR(1000)
);