CREATING A TABLE

[Anon]

I am running Welcome to phpMyAdmin 2.1.0
MySQL 3.23.37 running on localhost

but I am trying to create a table but it keeps saying

Error
SQL-query:

CREATE TABLE users (user_name MEDIUMTEXT (6) not null , user_password MEDIUMTEXT (15) not null , INDEX (user_name));
MySQL said: You have an error in your SQL syntax near \'(6) not null , user_password MEDIUMTEXT (15) not null , INDEX (user_name))\' at line 1

I used the add new table page but it came up with this message does anyone know what the right command is or what I could do to create a new table, many thanks

Jon

[nightowl]

you might want to post this message in the database-forum...

[Anon]

i don't think you can have text columns be index's i think you can only do that with INT.

[[deleted]]

That '(6)' is looks of place.
(serves no purpose at all in MySQL anyway)