赞
踩
-- 查询分区表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'
- ;
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。