PHP/mySQL question

[abie10]

I was going to post this in the help section, but it is mainly SQL and I was hoping that someone here could answer it. I put the following in a text file to create a new table. It was all in 1 line on the text file:

CREATE TABLE applied ( id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT, handle VARCHAR(40), wname VARCHAR(40), height VARCHAR(10), weight VARCHAR(10), age TINYINT(4), home VARCHAR(20), appear VARCHAR(40), ringatt VARCHAR(150), finish VARCHAR(50), desc VARCHAR(50), move VARCHAR(255), theme VARCHAR(50), biography BLOB(1000), PRIMARY KEY (id), UNIQUE id (id))

When I uploaded it with phpMyAdmin, I get the following error:

MySQL said:

You have an error in your SQL syntax near '(1000), PRIMARY KEY (id), UNIQUE id (id))' at line 1

Any idea where the error is?

[stuartc1]

maybe you should post this in the Database Forum, anyway the only thing that you may need to get this to work is a semi colomn (😉 at the end of the SQL .