-- Joe Stump <[EMAIL PROTECTED]> http://www.joestump.net "Label makers are proof God wants Sys Admins to be happy."
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 11:29 AM To: Joe Stump Subject: Re: InnoDB / MyISAM Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query,queries,smallint If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I've been looking into switching to InnoDB. I have a few questions though. 1.) Can I do joins between InnoDB / MyISAM tables? 2.) Do FK restraints work if the FK referenced is in a MyISAM table? I'm trying to get the best of both worlds. I'd have a data table with FULLTEXT and then have join tables, etc. InnoDB so I can have transactions and FK restraints. I've looked through the archives and couldn't find any answers to these questions. BTW, I'm using 4.0-gamma right now. --Joe -- Joe Stump <[EMAIL PROTECTED]> http://www.joestump.net "Label makers are proof God wants Sys Admins to be happy." --------------------------------------------------------------------- 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