使用存储过程和Event事件为Mysql表自动建立分区_MySQL

BEGIN#Routine body goes here...declare minMonitTime date default CURDATE();DECLARE partname   varchar(50);SET partname=CONCAT('part',CURDATE()-0);#首先新建一个分区set @v_add = CONCAT('ALTER TABLE part_tab12123  PARTITION BY RANGE COLUMNS(date)  (PARTITION partmin VALUES LESS THAN (/'1991-12-13/'))');        -- 定义预处理语句 prepare stm from @v_add;        -- 执行预处理语句execute stm;        -- 释放预处理语句deallocate prepare stm;set @v_add_s = CONCAT('ALTER TABLE part_tab12123  ADD PARTITION  (PARTITION ',partname,' VALUES LESS THAN (/'',minMonitTime,'/'))');        -- 定义预处理语句 prepare stmt from @v_add_s;        -- 执行预处理语句execute stmt;        -- 释放预处理语句deallocate prepare stmt;END

SELECT            partition_name part,             partition_expression expr,             partition_description descr,             table_rows     FROM            INFORMATION_SCHEMA.partitions     WHERE    	TABLE_NAME='表名';