[SOLVED] MSQL Table Creation Issue

[AKalair]

Hi guys,

Im using MySql 4.1.22 and im trying to create a table in a SSH window. I type this

 

mysql> CREATE TABLE (

    -> username, text

    -> password, text

    -> );

 

and get an error message

 

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(

username, text

password, text

)' at line 1

 

Can anyone help me?

 

Thanks

[Mchl]

You didn't specify name of the table

 

Bookmark this: http://dev.mysql.com/doc/refman/5.0/en/sql-syntax.html

and use often

[AKalair]

Thanks, I fixed that but still get an error ?

 

It looks right compared to that guide to

 

mysql> CREATE TABLE users (

    -> username, text

    -> password, text

    -> );

 

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql

[Mchl]

CREATE TABLE users (username text, password text);

 

[fenway]

Except that TEXT is the wrong choice for sure.

[Mchl]

Maybe these are Entish names and passwords. In other cases, TEXT is overkill.