error creating text field

wxdqz

New Member
I am trying to create a field in MySQL with type text but I get this error;

1064 - You have an error in your SQL syntax near '(2000)' DEFAULT '0') at line 1.

I am using MySQL front and the SQL is like this;

CREATE TABLE news(content TEXT (2000) DEFAULT '0')

Thanks for any help!
 
Back
Top