Hi Richard I'm writing a web application in PHP with a MySQL backend. I'm a novice at both PHP and MySQL having started with both about November last year and I'm also new to programming at large so please excuse any question which may seem obvious.
The foreign keys are to be used to enforce referential integrety in the application -- e.g. If I try to delete a specific entry from the 'town' table it won't allow me to if there are entries in the 'advertiser' table which refer to that town. At the moment I'm using a table called 'advertisers_towns' which stores the ID of each entity and thereby the relationship is maintained. But if I can have the foreign keys operating this would cut out the need for such a table and all the extra coding work which goes with it. I hope that explains why I'd like to use foreign keys. What do you think? Regards Luke ----- Original Message ----- From: "Richard Clarke" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 2:11 PM Subject: Re: InnoDB tables > Luke, > > How exactly will the foreign keys save you time? Please explain. > > Ric. > > ----- Original Message ----- > From: "Luke van Blerk" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, April 09, 2002 9:17 AM > Subject: InnoDB tables > > > > Hi everyone, > > > > I've been reading up about InnoDB tables and they seem to have lots of > > advantages. I'm particularly interested in using the foreign keys as this > > will save me some much need time. In the benchmark tests on the InnoDB > > website they show up faster than MyISAM tables but will foreign keys have > a > > slow down effect? And are there any issues I need to know about before > > switching to InnoDB tables? > > > > Thanks in advance > > Luke van Blerk > > > > mysql > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
