Re: Adding FK via Alter Table not working

2003-07-13 Thread Ryan Henderson
Firstly you need to index home_location_id in the customer table, then it should work. On 14/7/03 4:06 AM, "David Corsaut" <[EMAIL PROTECTED]> wrote: > trying to add a FK to an existing table, to see table > structures, alter table syntax and error refer to > http://sourcepost.sytes.net/sourcev

Re: Adding FK via Alter Table not working

2003-07-13 Thread Heikki Tuuri
David, - Original Message - From: "David Corsaut" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Sunday, July 13, 2003 11:07 PM Subject: Adding FK via Alter Table not working > trying to add a FK to an existing table, to see table > structures,

Adding FK via Alter Table not working

2003-07-13 Thread David Corsaut
trying to add a FK to an existing table, to see table structures, alter table syntax and error refer to http://sourcepost.sytes.net/sourceview.aspx?source_id=6332 = David L. Corsaut [EMAIL PROTECTED] mobile: 206.790.0969 __ Do you Yahoo!? SBC Yahoo! DSL - Now