MySQL Forums
Forum List  »  InnoDB

Re: "create table as select ..." failed with unknown reason
Posted by: harry sheng
Date: December 20, 2016 07:15AM

The last statement is STMT_4 with clause "limit 10";
the 2nd last statement is exactly STMT_4;
the 3rd last statement is STMT_3 with clause "limit 10".

The last statement is trying to create a temporary table from the SELECT statement of the 3rd last statement. The SELECT statements in the last 3 statements are exactly the same except the clause "limit 10".

Options: ReplyQuote

Written By
Re: "create table as select ..." failed with unknown reason
December 20, 2016 07:15AM

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.