Posted by Steve on 08/10/05 15:00

> "CREATE TABLE enquiries (id int(6) NOT NULL auto_increment,name varchar(80)
> NOT NULL,
> [...]
> varchar(80) NOT NULL,technology varchar(80) NOT NULL,desc blob NOT
> NULL,
> [...]

> " 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 '

DESC is a MySQL reserved word. See
<http://dev.mysql.com/doc/mysql/en/legal-names.html>. Quoting it will
solve your problem. When in doubt, quote it.

CREATE TABLE ... `desc` blob NOT NULL, ...

---
Steve

[Back to original message]