Get MySQL partition information

partition_info.sql

-- Get the unique PARTITION_EXPRESSION values
SELECT DISTINCT PARTITION_EXPRESSION
FROM information_schema.partitions;

-- Mappings
-- TO_DAYS() => FROM_DAYS()
-- UNIX_TIMESTAMP() => FROM_UNIXTIME()

SELECT TABLE_SCHEMA
, TABLE_NAME
, PARTITION_NAME
, CASE TRIM(SUBSTRING(PARTITION_EXPRESSION, 1, LOCATE('(', PARTITION_EXPRESSION)- 1 ))
WHEN 'TO_DAYS' THEN FROM_DAYS(PARTITION_DESCRIPTION)
WHEN 'UNIX_TIMESTAMP' THEN FROM_UNIXTIME(PARTITION_DESCRIPTION)
ELSE PARTITION_DESCRIPTION END AS PARTITION_DESCRIPTION
, TABLE_ROWS
FROM information_schema.partitions
WHERE TABLE_NAME = <table_name>
;