查看Mysql表分区语句

时间：2014-07-23 20:20:55 收藏：0 阅读：815

SELECT 
  partition_name part,  
  partition_expression expr,  
  partition_description descr,  
  table_rows  
FROM 
  INFORMATION_SCHEMA.partitions  
WHERE 
  TABLE_SCHEMA = schema()  
  AND TABLE_NAME=‘table‘;

查看Mysql表分区语句,布布扣,bubuko.com

原文：http://www.cnblogs.com/licous/p/3863691.html