mysql表分区

alter table t_result_part partition by range (unix_timestamp(create_time)) (
        partition p1 values less than (unix_timestamp('2021-10-01')),
        partition p2 values less than (unix_timestamp('2021-10-05')),
        partition p3 values less than (unix_timestamp('2021-10-10')),
        partition p4 values less than (unix_timestamp('2021-10-15'))
);

select
        partition_name part,partition_expression expr,partition_description descr,
        from_unixtime(partition_description,'%Y-%m-%d') expirydate,table_rows
from
        information_schema.`partitions` where table_name = 't_result_part';
        
        
    select * from    t_result_part;

select replace(partition_name,'p',"")  from information_schema.partitions where table_name = 't_result_part' and table_schema = 'test' order by partition_ordinal_position desc limit 1;