Re: Error in creating table

[Arie Nagel]

Try 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 TEXT,
keyword TEXT,
addinfo TEXT
);

I added the backticks as suggested by Shantanu and the TEXT column type (which is also a BLOB type).

If you want to find out about BLOBS see here: http://dev.mysql.com/doc/mysql/en/blob.html

Hope this helps.