MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Joe Stump Date:January 29 2003 10:35pm
Subject:RE: InnoDB / MyISAM
View as plain text  

--
Joe Stump <joe@stripped>
http://www.joestump.net
"Label makers are proof God wants Sys Admins to be happy."

-----Original Message-----
From: mysql@stripped [mailto:mysql@stripped]
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 <joe@stripped>
http://www.joestump.net
"Label makers are proof God wants Sys Admins to be happy."



Thread
RE: InnoDB / MyISAMJoe Stump29 Jan