mysql查询分区表的分布状态&&mysql查询无主键的表

mysql查询分区表的分布状态：

##MySQL 查看分区表的分布情况

SELECT table_name,partition_name,partition_description,table_rows 
FROM information_schema.PARTITIONS 
WHERE table_rows > 0 and table_name in ('table1','table2','table3');

mysql查询无主键的表

##查询无主键的表
SELECT
	table_schema,
	table_name 
FROM
	information_schema.TABLES 
WHERE
	( table_schema, table_name ) NOT IN ( SELECT DISTINCT table_schema, table_name FROM information_schema.COLUMNS WHERE COLUMN_KEY = 'PRI' ) 
	AND table_schema NOT IN ( 'sys', 'mysql', 'information_schema', 'performance_schema' );