|
|
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
Navigation:
[Reply to this message]
|