MySQL Forums
Forum List  »  Partitioning

how to remove partitiong in mysql version5.6
Posted by: heiansan white
Date: June 13, 2013 01:41AM

There is a table,my_table,which has not been created any parttition in mysql5.6. And I'm trying to create partitions by procedure in mytable,when I run this code:'alter table my_table remove partitioning', I'm getting this error:'1505 - Partition management on a not partitioned table is not possible'.But when I run above code in mysql version 5.5, this code can be run.
If my_table has been created parttitions, and when I run above code,not only mysql5.5 can run,but also mysql5.6 can run too.
I guess that if this code can be run, mysql5.6 need to be config some files.But I am not able to why.
Can you solve it, thanks in advance?

Options: ReplyQuote

Written By
how to remove partitiong in mysql version5.6
June 13, 2013 01:41AM

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.