how to set a database?

[Ewwa]

I set up a database in ther server side, when I save it , it said

Error
SQL-query :

CREATE TABLE userform (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, story TEXT(600) NOT NULL, name VARCHAR(30) NOT NULL, mail VARCHAR(30) NOT NULL, sex CHAR(1) NOT NULL, INDEX (story, name, mail, sex))

MySQL said:

You have an error in your SQL syntax near '(600) NOT NULL, name VARCHAR(30) NOT NULL, mail VARCHAR(30)

Can you tell me how can I set a database?Thank you!

[stolzyboy]

php is generally cake, compared to other languages like PERL, anyway, check out phpMyAdmin, do a google search, this will give you a GUI-Like interface to making databases and tables, etc.............

[Z3RatuL]

you don't need to specify length for text in mySQL. Simply remove the (600) text from it and it will work.

CREATE TABLE userform (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, story TEXT NOT NULL, name VARCHAR(30) NOT NULL, mail VARCHAR(30) NOT NULL, sex CHAR(1) NOT NULL, INDEX (story, name, mail, sex))

[stolzyboy]

you may not need to specify the length for the text in mysql, but i am pretty sure that it doesn't make a difference regardless, just leaving it blank would be better than anything for text, IMHO

[barand]

Indexing on story could slow things down nicely.