okay, so my tables have to be of type InnoDB. Is there a configuration file somewhere where i can specify that all my tables be InnoDB so I don't have to keep manually specifying the type?
blue ----- Original Message ----- From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 02, 2002 11:45 AM Subject: Re: cascading, referential integrity > Blue, > Tuesday, July 02, 2002, 5:54:32 PM, you wrote: > > BP> does mysql 3.23 support cascading and referential integrity or is this only > BP> part of 4.01? if so, how do i take advantage of it and where in the > BP> documenation (link) can I read about it? > > Yes, MySQL supports foreign key constraints for referential integrity > and foreign keys present since in 3.23.43b. > > CASCADE DELETE is supported since 3.23.50: > http://www.mysql.com/doc/S/E/SEC446.html > > > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > --------------------------------------------------------------------- > 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