MySQL Forums :: Partitioning :: Select using partition dynamically


Advanced Search

Re: Select using partition dynamically
Posted by: Rick James ()
Date: May 11, 2015 12:53PM

Normally "Explicit Partition Selection" is unnecessary. The WHERE clause would specify some thing that do the "pruning" for you.

Please explain why you want it? I am curious.

It cannot be constructed in that manor, just as LIMIT and table name cannot be.

Consider using a Stored Procedure with CONCAT, prepare, and execute.

(That feature was added in 5.6.2)

Options: ReplyQuote


Subject Views Written By Posted
Select using partition dynamically 1559 Jose Lima 05/07/2015 06:21PM
Re: Select using partition dynamically 803 Rick James 05/11/2015 12:53PM


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.