用MySQL自动创建和修改分区

1、自动创建分区

CREATE DEFINER=`root`@`%` PROCEDURE `PROC_CREATE_Partition`(i_tableName VARCHAR(40), i_fieldName VARCHAR(30), i_startDate date, i_endDate  date, i_freq VARCHAR(2))
LEAVE_SIGN:BEGIN
/*入参说明
i_tableName:表名称
i_fieldName:字段名
i_startDate:开始日期
i_endDate:结束日期
i_freq:频率（月、季度、半年、年）*/
		 SET @v_nowTime = date(NVL(@i_endDate , NOW()));
     SET @v_startDate = date(@i_startDate);
		 IF @i_freq = '月' THEN
			SET @v_monthNum = 1;
			# 求当前日期第二个月的月初
			SET @v_endDate = DATE_SUB(DATE_ADD(@v_nowTime, INTERVAL 2 MONTH),INTERVAL EXTRACT(DAY FROM @v_nowTime) - 1 DAY);
		 ELSEIF @i_freq = '季度' THEN 
		  SET @v_monthNum = 3;
			#求当前日期的第二个季度初
			SET @v_endDate = DATE_ADD(MAKEDATE(EXTRACT(YEAR FROM @v_nowTime), 1), INTERVAL QUARTER(@v_nowTime)+1 QUARTER);
		 ELSEIF @i_freq = '半年' THEN
			SET @