MySQL Forums
Forum List  »  Newbie

Can't finish createing table query in DOS command line
Posted by: Julie MASV
Date: July 02, 2005 01:18PM

Hello,

I am trying to create a table from DOS command. But till certail point, I can't type more and the creat table query hasn't been finished. Is there some buffer size that I can reset to enlarge the buffer for creating table?

The table I wanted to create is not big:

Create table models(mid int, model_name char(30), pid int, cid int, description char(100), primary key(mid), foreign key(pid) references product(pid) on delete cascade on update cascade, foreign key(cid) references category(cid) on delete cascade on update cascade) type=innodb;

The point that I can't type more: the last delete cascade....till the ;.

Please help me with this issue since I can't continue with the project!!

Thanks a lot
Julie

Options: ReplyQuote


Subject
Written By
Posted
Can't finish createing table query in DOS command line
July 02, 2005 01:18PM


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.