MySQL Forums
Forum List  »  Partitioning

Re: How to move partition files
Posted by: Phil Hildebrand
Date: October 05, 2008 08:39PM

Select * from table#partition is not really possible, but you can do:

select * from table
where <partition key> = <value>

IE: just select all the data for the given partition by filtering on the partition key value.

Options: ReplyQuote


Subject
Views
Written By
Posted
12615
March 05, 2008 03:06PM
4095
October 01, 2008 07:39PM
Re: How to move partition files
3569
October 05, 2008 08:39PM
3569
October 08, 2008 10:45PM


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.