Re: ADD CONSTRAINT on InnoDB tables

2003-06-09 Thread Heikki Tuuri
Marco, - Original Message - From: "Marco B" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, June 09, 2003 8:45 PM Subject: ADD CONSTRAINT on InnoDB tables > Hi all,=0D=0A=0D=0AI've just installed mysql 4.0.1 on my pc and I'm tryin

ADD CONSTRAINT on InnoDB tables

2003-06-09 Thread Marco B
Hi all, I've just installed mysql 4.0.1 on my pc and I'm trying to migrate a set of old MyISAM table to InnoDB type table, to introduce referential integrity on my data. I found this problem. I create an index for each key in the references and the sql command ALTER TABLE utenti ADD CONSTRAINT