Posted by Michael Phipps on 08/10/05 15:03

> "CREATE TABLE enquiries (id int(6) NOT NULL auto_increment,name
> varchar(80) NOT NULL,email varchar(80) NOT NULL,company varchar(80) NOT
> NULL,telephone varchar(80) NOT NULL,country varchar(80) NOT NULL,city
> varchar(80) NOT NULL,organisation varchar(80) NOT NULL,problem
> varchar(120) NOT NULL,sector varchar(80) NOT NULL,technology varchar(80)
> NOT NULL,desc blob NOT NULL,files blob NOT NULL,PRIMARY KEY (id),UNIQUE id
> (id),KEY id_2 (id))"
> and I get the response,
> " Invalid query: You have an error in your SQL syntax near 'desc blob NOT
> NULL,files blob NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 ' at
> line 1 ".
>
> Does anyone have any idea what I could be doing wrong? If I remove the
> blob entries it works.

SQL isn't my forte - but I'll take a guess:

Can you use "desc" as a field name? isn't it a reserved word? As in
....order by xxx desc;

[Back to original message]