MySQL adds one partition per month and queries all partitions

Create PROCEDURE usp_partition () begindeclare _time datetime;declare num int;declare _p VARCHAR (DEFAULT p;declare p1 VA) Rchar (20);/* Gets the first day of the next one months */select Date_add (Curdate ()-day (Curdate ()) +1,interval 1 month) as _time;/* remove the '-' in the time */select REPLACE (_time, '-', ') as Num; SELECT _p+num as P1; SET concat (' ALTER TABLE BOOK8 ADD PARTITION (PARTITION p ', p1, ' VALUES less THAN (to_days (' "', Yearweek (p1), '))); END

Querying all partitions

Select Partition_name part, Partition_expression expr, partition_description descr, table_rows from Informatio N_schema.partitions WHERE Table_schema = Schema () and table_name= ' Book9 ';

MySQL adds one partition per month and queries all partitions