MySQL Forums
Forum List  »  InnoDB

NEW TO MYSQL - TABLE CREATION
Posted by: malathi amudhan
Date: April 25, 2005 11:38PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
NEW TO MYSQL - TABLE CREATION
3281
April 25, 2005 11:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.