Jump to content

[SOLVED] MSQL Table Creation Issue


AKalair

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/124053-solved-msql-table-creation-issue/
Share on other sites

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.