MySQL Forums
Forum List  »  Memory Storage Engine

Re: When using Memory Storage Join ON Clause would not work anymore
Posted by: Rick James
Date: January 06, 2015 11:46AM

Please provide
SHOW CREATE TABLE iprooptions

It seems like you could get rid of the NOT NULL tests if you changed LEFT JOINs to plain JOINs.

> My Problem is, when I now surround this select with a Create Temporary Table tmp Enginge=Memory

Let's see the entire statement; perhaps there is some subtle problem in the syntax or spelling.

> Don't matter about the Select please.

Sometimes cleaning up the code makes the problem go away!

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: When using Memory Storage Join ON Clause would not work anymore
1432
January 06, 2015 11:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.