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 like this. CREATE TABLE ITEM_CAT_REL ( id INT, cat_id INT NOT NULL, key(id), FOREIGN KEY (id) references ITEM(id) on

Re: Alter InnoDB to MyISAM Part2

Purcell [EMAIL PROTECTED] To: mysql@lists.mysql.com 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 like

Re: Alter InnoDB to MyISAM Part2

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,