56,940
社区成员




SELECT TABLE_NAME,PARTITION_DESCRIPTION
FROM `information_schema`.`PARTITIONS`
WHERE table_schema = 'xxxx'
AND LENGTH(PARTITION_DESCRIPTION) = 13
AND PARTITION_NAME IS NOT NULL
ORDER BY PARTITION_DESCRIPTION DESC;
SELECT TABLE_NAME,PARTITION_DESCRIPTION
FROM `information_schema`.`PARTITIONS`
WHERE table_schema = 'xxxx'
AND LENGTH(PARTITION_DESCRIPTION) = 13
AND PARTITION_NAME IS NOT NULL
AND TABLE_NAME LIKE 'xxx%'
ORDER BY PARTITION_DESCRIPTION DESC ;