Mysql分区表查询

-- 查询分区表test-xxx的情况

SELECT *
FROM information_schema.`PARTITIONS` 
WHERE TABLE_SCHEMA=SCHEMA() AND TABLE_NAME='test-xxx'
;

-- 获知根据时间分区，2023-02-01的分区名叫做t20230201，分区的时间字段为xxx_date，单独对该分区查询

-- explain
SELECT p.id
-- ,p.*
from `test-db`.test-xxx PARTITION(t20230201) AS p  
WHERE 1=1
and p.xxx_date ='2023-02-01 00:00:00'
;