On Fri, Jan 10, 2003 at 04:54:14PM +0200, Octavian Rasnita wrote: > Hi all, > > Is MySQL able (like MS Access) to define permanent relations between tables? > > For example, I want to define a master - child relation between 2 tables so > when deleting some entries from the master table to automaticly delete the > entries from the details table without specifying this in the query.
Dear Teddy, The InnoDB table type supports this type of functionality - see http://www.mysql.com/doc/en/SEC449.html for more details Cheers! -- Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Upgrading your servers to 4.0.8? Make sure to upgrade your clients to 4.0.8 as well! See http://mysql.com/doc/en/News-4.0.8.html "While we are postponing, life speeds by." --Lucius Annaeus Seneca --------------------------------------------------------------------- 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