MySQL Forums
Forum List  »  Partitioning

Re: Convert non-partitioned -> partitioned
Posted by: Mikael Ronström
Date: August 21, 2006 02:01AM


You simply write:
ALTER TABLE table_name

followed by exactly the same partitioning syntax you would have used
if you were to create the table.

Rgrds Mikael

Luca Ghezzo Wrote:
> 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

Written By
Re: Convert non-partitioned -> partitioned
August 21, 2006 02:01AM

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.