"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,
You should be able to pull the ID of the parent table in when you do the
INSERT ... SELECT to pull the data in, in which case, the IDs in the foreign
key fields would still be valid.
I'd convert them all to MyISAM rather than doing half and half.
- Original Message -
From: "Scott Purc
