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 ;上面的一段sql查不到数据,下面的这段sql可以查看数据
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 ;上面的一段sql查不到数据,下面的这段sql可以查看数据
灵异的是上段居然查不到数据,下段可以查到