MySQL list partition information

# SQL Query
select TABLE_SCHEMA as db, partition_name as name, PARTITION_METHOD as method, partition_expression as exp, table_rows as 'nb_records', PARTITION_DESCRIPTION as 'description' from information_schema.partitions where partition_name IS NOT NULL;