MySQL Forums
Forum List  »  Partitioning

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

Hi,

You simply write:
ALTER TABLE table_name
PARTITION BY ...

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


Subject
Views
Written By
Posted
Re: Convert non-partitioned -> partitioned
2283
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.