Posted by Charles Keepax on 08/10/05 14:48

Hi I am having some problems using MySQL. I am trying to create a table in a
database using the query
"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.

Thanks in advance,
Charles

• Next in forum: Re: Create Tabel
• Prev in forum: Re: Suggestions for a development/testing environment?
• Thread view: Create Tabel

[Reply to this message]