Why Do I get This Error

[E]

and how can i fix it....

this is wat it says when i try to make a table

SQL-query :

CREATE TABLE `download` (`id` MEDIUMINT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, `userid` MEDIUMINT(10) NOT NULL, `link` MEDIUMTEXT(100) NOT NULL, `artist` TEXT(50) NOT NULL, `title` TEXT(75) NOT NULL, `date` DATE(20) NOT NULL)

MySQL said:

You have an error in your SQL syntax near '(100) NOT NULL, `artist` TEXT(50) NOT NULL, `title` TEXT(75) NOT NULL, `date` DA' at line 1

[g-force2k2]

E just take the mediumtext(100) and change it to mediumtext... when i use that i don't define it with a value but i could be wrong... regards...

g-force2k2

[E]

i will try it
thx

[g-force2k2]

btw E if you wanted to set a limit just change the mediumtext to varchar(100) regards

g-force2k2

[Dark_Wizard]

Hmmm...there is nothing wrong with that query. I would remove the apostrophes as this seems to be causing issues for some people and has been verified.