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/