Beginner help with simple tasks

[loopykd]

I am using the following query in the MySQL For Dummies book and I am getting the following result. Why is this happening? I then go to MODIFY the table to change the data type in the zip to char and it won't do it.

create table Member (
loginName varchar(20) NOT NULL,
createDate date NOT NULL,
password varchar(255) NOT NULL,
lastName varchar(50),
firstName varchar(40),
street varchar(50),
city varchar(50),
state char(2),
zip char(15),
email varchar(50),
phone char(25),
fax char(25),
primary key(loginName) )

loginName varchar(20) PRI

createDate date 0000-00-00

password varchar(255)

lastName varchar(50) YES

firstName varchar(40) YES

street varchar(50) YES

city varchar(50) YES

state char(2) YES

zip varchar(10) YES

email varchar(50) YES

phone varchar(15) YES

fax varchar(25) YES

I know this is simple and I should probably let it go and move on but it shouldn't be this way and it's bugging me. Thanks for all your expert help.

[bogu]

Hi I thing you did not understand what is your sql sintax.
You try this and it didn't work:

create table Member (
loginName varchar(20) NOT NULL,
createDate date NOT NULL,
password varchar(255) NOT NULL,
lastName varchar(50),
firstName varchar(40),
street varchar(50),
city varchar(50),
state char(2),
zip char(15),
email varchar(50),
phone char(25),
fax char(25),
primary key(loginName) )

Just try this sql.