MySQL数据库怎么按每月分区_MySql数据库中对表进行按月份的分区 那么表的分区会根据时间的增加而自己增加分区么...

1、建立分区表

[sql] view plain copy

create table test_log

(

created datetime,

msg varchar(2000)

)partition by range columns(created)(

partition p20150301 values less than('2015-03-02')

);

2、增加分区的命令

[sql] view plain copy

alter table test_log add partition (partition p20150302 values less than('2015-03-03'));

3、删除分区的命令

[sql] view plain copy

alter table test_log drop partition p20150301;

4、查询分区信息

[sql] view plain copy

SELECT partition_name,

cast(replace(partition_description, '''', '') AS date) AS val

FROM INFORMATION_SCHEMA.PARTITIONS

WHERE TABLE_NAME = 'test_log' AND TABLE_SCHEMA = 'test';

+----------------+------------+

| partition_name | val |

+----------------+---------