mysql 分区啊 高手们帮帮忙吧。。。

我想把表t_replyinfo 分四个区 我的表已经创建了 并且有很多数据 我现在要修改 给它设置个分区来提高效率

我的方法是：
SQL code:

update table t_replyinfo partition by range (id)( partition p0 values less than (100000) data directory = "/data00/" index directory = "/data00/",
partition p1 values less than (200000) data directory = "/data00/" index directory = "/data00/",
partition p2 values less than (300000) data directory = "/data00/" index directory = "/data00/",
partition p3 values less than maxvalue data directory = "/data00/" index directory = "/data00/"
)



报错内容：
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table t_replyinfo partition by range (id)( partition p0 values less than (100000' at line 1

---

引用

我想把表t_replyinfo 分四个区 我的表已经创建了 并且有很多数据 我现在要修改 给它设置个分区来提高效率

我的方法是：
SQL codeupdatetable t_replyinfo partitionby range (id)( partition p0values less than (100000) data directory= "/data00/"index directory= "/data00/",
partition p1values less than (200000) data directory= "/data00/"index directory= "/data00/