php读取MySQL获取分区名称及属性信息的查询语句

//获取分区名称及属性信息;
$sql = "SELECT partition_name part,partition_expression expr,partition_description descr,table_rows FROM INFORMATION_SCHEMA.partitions WHERE TABLE_SCHEMA = schema() AND TABLE_NAME = 'jk_data'";
$res = $db->query($sql);
$res->setFetchMode(PDO::FETCH_ASSOC);
$count = $res->rowCount();
$data = $res->fetchAll();
echo "
";
var_dump($data);
 
Done!