NEW TO MYSQL - TABLE CREATION

[malathi amudhan]

Hi there,

Following is the table structure.
TABLE STRUCTURE:

Intrusion1 char(1)
Intrusion2 char(1)
Intrusion3 char(1)
intrusion4 char(1)
Own char(1)
Rent char(1)
Monitored1 char(1)
Monitored2 char(1)
CompanyName varchar(20)
FirstName varchar(20)
LastName varchar(20)
Address1 varchar(15)
Address2 varchar(15)
City varchar(20)
State varchar(2)
Zip varchar(10)
BestTime varchar(10)
OtherInfo varchar(10)

I am trying to create a TABLE using CREATE TABLE syntax, I could type

the FIELD NAME & TYPE till 'Address1' without any problem, but I

couldn't type any further(the cursor wouldn't let me type anyfurther,

it is just STANDSTILL) to complete the TABLE. BUT NEW TABLE IS CREATED WHEN I CREATE TABLE USING 6 FILEDS ALONE !!!!.
wondering how to create the entire table. I really appreciate your time & help.

Thanks.