Re: Convert non-partitioned -> partitioned

[Mikael Ronström]

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