mysql每天自动新建分区，删除分区和备份

1：新增分区

CREATE DEFINER=`root`@`%` PROCEDURE `proc_create_partition`(`tableName` varchar(128),`timeColName` varchar(128))
BEGIN
	DECLARE p_id int;
    DECLARE nextDate date;
    DECLARE lastDate LONG;
    DECLARE p_name varchar(16);
    
    SELECT COUNT(partition_name) INTO p_id 
    FROM INFORMATION_SCHEMA.partitions
    WHERE TABLE_NAME=tableName;
    
    IF p_id=0 THEN
        
        SELECT DATE_ADD(CURDATE(),INTERVAL 1 DAY) INTO nextDate  
        FROM DUAL;
 
        SET p_name=DATE_FORMAT(CURDATE(),'%Y%m%d');
        SET @v_add=CONCAT('ALTER table ',tableName
                ,' PARTITION by range(TO_DAYS('
                , timeColName
                ,'))(partition '
                , CONCAT('p',p_name)
                ,' values less than (TO_DAYS("'
                , nextDate,'")))');
 
   ELSE
 
        SELE