problem with simple SQL command

[tchthsky]

I am new at this.
I am trying to execute this command:

CREATE TABLE table_name (
-> column_1_name column_1_type column_1_details,
-> column_2_name column_2_type column_2_details,
-> );

from a mysql> prompt and am getting the following error:

ERROR 1064: You have an error in your SQL syntax near 'column_1_type column_1_details,
column_2_name column_2_type column_2_details' at line 2


I'm copying the commands directly from a web page and I've looked over the consistancy of the text, but I can't figure it out, obviously.

Any information would be much appreciated.

Thanks.

Rob

[filmfoto]

Here is a real world example:

CREATE TABLE User (
   ID int(11) NOT NULL auto_increment,
   Name varchar(30) NOT NULL,
   Email varchar(200) NOT NULL,
   PRIMARY KEY (ID)
);

Here is a link to the mysql manual, with more info on creating tables.

Hope this gets you going.




Cheers.

[Aes]

That's because that is giving you a layout, not the exact commands. For example, column_1_type can be either varchar(), char(), text, int, blob, date, et cetera. column_1_details can be primary key, not null, unique, et cetera.

So a general command would be something like:

-> CREATE TABLE table_name (
-> column_1_name varchar(30) not null primary key,
-> column_2_name text not null);

Are you following? Go to the documentation at MySQL.com and you'll be able to easily find the syntax to be used when creating tables.

-Colin