Re: InnoDB Foreign Key Constraint Issue

2003-09-19 Thread David Griffiths
day, September 18, 2003 11:50 PM Subject: Re: InnoDB Foreign Key Constraint Issue > David, > > - Original Message - > From: "David Griffiths" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.myodbc > Sent: Friday, September 19, 2003 4:07 AM > Subject: In

Re: InnoDB Foreign Key Constraint Issue

2003-09-18 Thread Heikki Tuuri
David, - Original Message - From: "David Griffiths" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, September 19, 2003 4:07 AM Subject: InnoDB Foreign Key Constraint Issue > The following constraint is failing: > > ALTER TABLE address_li

InnoDB Foreign Key Constraint Issue

2003-09-18 Thread David Griffiths
The following constraint is failing: ALTER TABLE address_list ADD CONSTRAINT FOREIGN KEY (address_type_id) REFERENCES address_type (address_type_id); The address_list table looks like: mysql> desc address_list; +--+--+--+-+-+---+ | Field