MySQL Forums :: InnoDB :: "create table as select ..." failed with unknown reason


Advanced Search

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


Subject Views Written By Posted
"create table as select ..." failed with unknown reason 290 harry sheng 12/19/2016 07:17PM
Re: "create table as select ..." failed with unknown reason 160 Peter Brawley 12/19/2016 10:21PM
Re: "create table as select ..." failed with unknown reason 171 harry sheng 12/20/2016 07:15AM
Re: "create table as select ..." failed with unknown reason 140 Peter Brawley 12/20/2016 12:58PM
Re: "create table as select ..." failed with unknown reason 187 harry sheng 12/20/2016 09:47AM


Sorry, only registered users may post in this forum.

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.