MySql: create table error

Shell Programming and Scripting
1

Hi, iam learning MySql. Iam trieing to create a table in the database "guestbook"

at the command line in mysql heres what i type but i get a error

mysql>create table guestbook

->(
-> name varchar(40) null.
-> url varchar(40) null.
-> comments text null.
->)
->;

ERROR 1064: You have a error in you SQL syntax near 'name varchar(40) null.' at line 2.

Whats wrong??? How should i write this command?
by the way, the bold parts are the parts that mysql show at the command line.

2

At least part of the problem is that you're using periods instead of commas. Try this:

create table guestbook
(name varchar(40) null,
url varchar(40) null,
comments text null
)
3

worked, thanks !

4

hey the reply and questions are from the same persons i suppose:p