Re: Help Foreign Key Error

2005-07-01 Thread SGreen
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 07/01/2005 03:46:49 PM: > Hello, > > > MYSQL on PC v 4.0.15 > > And I am trying to add an address table off of it. Using the > users(id) as a primary key and deleting on cascade. So when the user > is deleted from system, so are the addresses associ

Help Foreign Key Error

2005-07-01 Thread Scott Purcell
Hello, MYSQL on PC v 4.0.15 And I am trying to add an address table off of it. Using the users(id) as a primary key and deleting on cascade. So when the user is deleted from system, so are the addresses associted with him. // code that errors CREATE TABLE `address` ( `id` int(11), `create