MySQL Forums
Forum List  »  Partitioning

Re: How to create partition on existing table?
Posted by: Ikrom Hotamov
Date: July 02, 2009 02:08AM

Well, I'm a little new to MySQL, but.. why not do it manually?
I mean, rename your table, create the table you want, with the partitioning info and all the columns you want to be altered. Then dump all the data into the new table, and drop the old one?
Or doesnt it work with partitioned tables?

Options: ReplyQuote

Written By
Re: How to create partition on existing table?
July 02, 2009 02:08AM

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.