Mysql自动分区

# 按时间为表创建分区（此条覆盖当前分区） 只用于初始化
#ALTER TABLE seek_radio_gps PARTITION BY RANGE (time)
#(partition p20210601 values less than (unix_timestamp('2021-06-01'))
#)

# 手动新增分区 只用于特殊情况处理
#ALTER TABLE seek_radio_gps
#            ADD PARTITION (PARTITION p20210701 VALUES LESS THAN (UNIX_TIMESTAMP('2021-07-01')))
            
            
# 按月自动新增分区
SELECT REPLACE(partition_name,'p','') INTO @P12_Name FROM INFORMATION_SCHEMA.PARTITIONS
            WHERE table_name='seek_radio_gps' ORDER BY partition_ordinal_position DESC LIMIT 1;
SET @Max_date= DATE(DATE_ADD(@P12_Name+0, INTERVAL 1 MONTH))+0;
#SELECT @Max_date
SET @s1=CONCAT('ALTER TABLE seek_radio_gps
            ADD PARTITION (PARTITION p',@Max_date,' VALUES LESS THAN (UNIX_TIMESTAMP(''',@Max_date,''')))');
SELECT @s1;
PREPARE stmt2 FROM @s1;
EXECUTE stmt2;
DEALLOCATE PREPARE stmt2;