Can't finish createing table query in DOS command line
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
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.