Re: Primary key / foreign key question

2008-11-10 Thread Martijn Tonies
Hello Steve, > Ok, I'm a little new a this, so be gentle!! :) > > I was looking into the InnoDB engine for some tables I have, and would like > to use the PK/FK on some of the data. > > It appears that the PK/FK is mainly used for updating/deleting data, > correct? I can't use it to retreive data

Primary key / foreign key question

2008-11-10 Thread Steve Grosz
Ok, I'm a little new a this, so be gentle!! :) I was looking into the InnoDB engine for some tables I have, and would like to use the PK/FK on some of the data. It appears that the PK/FK is mainly used for updating/deleting data, correct? I can't use it to retreive data from multiple tables