Exchange 分区的 MySQL ALTER 语句引发语法错误

Question

我遵循了此文档中给出的 Exchange 分区语法:https://docs.oracle.com/cd/E17952_01/refman-5.6-en/partitioning-management-exchange.html但是，它会引发语法错误。

ALTER TABLE e EXCHANGE PARTITION p0 WITH TABLE e2   

Error Code: 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 'EXCHANGE PARTITION p0 WITH TABLE e2' at line 1

谁能告诉我如何纠正这个问题吗？注:表 e、e2 已创建。Mysql版本:5.2.40

Answer 1

这是 MySQL documentation 的摘录

In MySQL 5.6, it is possible to exchange a table partition or subpartition with a table using ALTER TABLE pt EXCHANGE PARTITION p WITH TABLE nt,

您收到错误，因为 MySQL5.2 版本不支持它。要进行检查，请尝试在文档 URL[Magic Trick] 中将版本 5.6 更改为 5.2。