SQL syntax error!!! please Help

[neroninja]

Hi

I'm using the sitepoint book Build Your Own Database Driven Website Using PHP & MySQL and I am creating my first table I have copied the script as I have seen in the book and I'm getting a SQL syntax error

CREATE TABLE table_name (

column_1_name column_1_type column_1_details,
column_2_name column_2_type column_2_details,
...
);

when I type this in I get the following back!

MySQL said:
#1064 - 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 'column_1_type column_1_details,
column_2_name column_2_type co

what am I doing wrong???

[r937]

you're supposed to substitute some actual names, datatypes, and details for each of those

for example,

CREATE TABLE customers
( customerid integer not null primary key
, customername varchar(99) not null
...
);

[neroninja]

thanks very much, I went back to the book and figured that out it's not written very well in regard to someone who is a novice, following it to the letter and got confusded! but thanks for your help....