– 查看mysql分区名和各分区数据量
SELECT table_name, partition_name, table_rows
FROM information_schema.PARTITIONS
WHERE table_name=‘test2_partition’;
附加2位前辈博客，讲解分区很细致
https://www.cnblogs.com/pejsidney/p/10074980.html
https://blog.csdn.net/a8240357/article/details/90234755
文章知识点与官方知识档案匹配，可进一步学习相关知识
MySQL入门技能树SQL高级技巧CTE和递归查询66146 人正在系统学习中