MySQL Forums
Forum List  »  Partitioning

Convert non-partitioned -> partitioned
Posted by: Luca Ghezzo
Date: August 18, 2006 03:10AM

Hello,

I'm having a look at MySQL docs about partitioning, and it sounds quite interesting. But I didn't find any referring to how to convert a non-partitioned table to a partitioned one, other than simply recreate and import data from a dump, of course, which would be quite uncomfortable if that table is constantly populated. So I was wondering if any special syntax (something like ALTER TABLE ... PARTITION ... or whatsoever) is provided to get such a result.

Thank you in advance.
Luca

Options: ReplyQuote


Subject
Views
Written By
Posted
Convert non-partitioned -> partitioned
3249
August 18, 2006 03:10AM


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.