MySQL Forums
Forum List  »  Partitioning

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


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.

Options: ReplyQuote

Written By
Convert non-partitioned -> partitioned
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.