# [EMAIL PROTECTED] / 2003-06-25 14:03:17 +0100:
> Im altering a number of table from MyISAM to innoDb and adding foreign
> keys.
>
> The alteration of the table type works.
> Adding the row as an index works.
> Adding the foreign key fails, generating the error:
>
> alter table project add FORE
Hi All,
Im altering a number of table from MyISAM to innoDb and adding foreign keys.
The alteration of the table type works.
Adding the row as an index works.
Adding the foreign key fails, generating the error:
alter table project add FOREIGN KEY (company_id) references company (id)
[mySQL] E
