HELP! Error creating table
I tried creating a table called "sales" to a ticketsales database. I used Mysql Admin to create my colums. This is what I came up with:
CREATE TABLE 'ticketsales'.'sales' (
'salesid' INTEGER UNSIGNED
'first' VARCHAR(20),
'last' VARCHAR(25),
'address' VARCHAR(35),
'city' VARCHAR(25)
'state' VARCHAR(2),
'zipcode' VARCHAR(5)
'dayphone' VARCHAR(20),
'evephone' VARCHAR(20),
'email' VARCHAR(50)
'no_of_tickets' INTEGER UNSIGNED,
'ticket_cost' INTEGER UNSIGNED,
'total_cost' INTEGER UNSIGNED
'credit_card_type' SET('VISA','AMERICAN EXPRESS','MASTERCARD'),
'fullname_on_card' VARCHAR(50),
'credit_card_no' VARCHAR(50),
'expiration date' DATE,
PRIMARY KEY('salesid')
)
I continue to receive this error message:
MYSQL Error Number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MYSQL version for the right syntax to use.
'fullname_on_card' VARCHAR(50),
'credit_card_no' VARCHAR(50),
'expiration date' DATE,
What am I doing wrong?