Re: Alter InnoDB to MyISAM Part2

2005-05-25 Thread SGreen
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 05/25/2005 09:22:32 AM: > I can do this programatically, and will alter the table. But there > are three tables that have foreign key references to the table I > will be altering. > > They look like this. > CREATE TABLE ITEM_CAT_REL ( > id INT,

Re: Alter InnoDB to MyISAM Part2

2005-05-25 Thread Jeremiah Gowdy
quot;Scott Purcell" <[EMAIL PROTECTED]> To: Sent: Wednesday, May 25, 2005 6:22 AM Subject: Alter InnoDB to MyISAM Part2 I can do this programatically, and will alter the table. But there are three tables that have foreign key references to the table I will be altering. They look li

Alter InnoDB to MyISAM Part2

2005-05-25 Thread Scott Purcell
I can do this programatically, and will alter the table. But there are three tables that have foreign key references to the table I will be altering. They look like this. CREATE TABLE ITEM_CAT_REL ( id INT, cat_id INT NOT NULL, key(id), FOREIGN KEY (id) references ITEM(id) on