See http://www.innodb.com Regards, Iikka
ps. The MySQL manual also offers some rough guidelines on where InnoDB excels. On Fri, 13 Sep 2002, Meidling, Keith, CTR, OSD-C3I wrote: > I've seen a lot about 'InnoDB'. What is it? > > -----Original Message----- > From: Weaver, Walt [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 12, 2002 4:09 PM > To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] > Subject: RE: simple query question > > > I'd use the InnoDB table type and establish a primary key/foreign key > relationship (parent-child) between the two. That way referential integrity > will be done for you by the database. > > --Walt Weaver > Bozeman, Montana > > -----Original Message----- > From: Chris Burger [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 12, 2002 1:57 PM > To: [EMAIL PROTECTED] > Subject: simple query question > > > I have I hope a simple query question. > > > > I have two tables > > 1 One has customer id and a store id and transaction information > > 2 Second has a store id and store information > > > > There is multiple transactions in the first table, however there is > only one record for each store id in the second table. What I need to > make sure is that for every store id in the first table I have a > corresponding store id record in the second table? > > > > > Any suggestions would be appreciated. > > > > Chris Burger > > > > --------------------------------------------------------------------- > 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 > ****************************************** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ****************************************** --------------------------------------------------------------------- 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