[摘要]+----------+ 1 row in set (0.00 sec) //删除一个分区 mysql> alter table aa drop partition p2; Query OK,...
+----------+
1 row in set (0.00 sec)
//删除一个分区
mysql> alter table aa drop partition p2;
Query OK, 0 rows affected (0.30 sec)
Records: 0 Duplicates: 0 Warnings: 0
//只有11条了，说明对现有的表分区成功了
mysql> select count(*) from aa;
+----------+
关键词：mysql分区技巧详细说明及案例代码区分