MySQL Forums
Forum List  »  Partitioning

Re: SQL on partitioned table
Posted by: Phil Hildebrand
Date: November 01, 2008 12:21PM

I dont' think it is...

you'd have to just do the full select from partition with the same restriction as the partition istelf:

select * from my_part_table where my_part_column = '2008-10-30';

that should only look at the one partition if that partition contains only rows with '2008-10-30'

What's the end goal? You might be able to use the information_schema partitions table if you are trying to do some automated partition switching or loading...

Options: ReplyQuote


Subject
Views
Written By
Posted
3368
October 30, 2008 04:39AM
2432
October 31, 2008 08:47AM
Re: SQL on partitioned table
2389
November 01, 2008 12:21PM


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.