MYSQL help needed

[newton1]

Hi All

I am having troubles trying to create my first table in mysql

I am using version 5.0

I have entered the code below in mysql:

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

and i get the following error:

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 'column_1_type column_1_details,column_2_name column_2_type column_2_details,' at line 2

Anyone able to help?

[r937]

"column_1_type" is not a valid datatype

you need something like DATETIME, INTEGER, or VARCHAR(42)

nor will "column_1_details" work either, you actually have to code some valid details, like PRIMARY KEY, NOT NULL, DEFAULT 'no way', and so on