mysql找出没有主键的表

select t.TABLE_SCHEMA ,t.TABLE_NAME,px.COLUMN_KEY  
from  information_schema.tables t
left join (
select distinct c.TABLE_SCHEMA,c.TABLE_NAME,c.COLUMN_KEY from information_schema.`COLUMNS` c where c.COLUMN_KEY='PRI'
) px on t.TABLE_SCHEMA = px.TABLE_SCHEMA and t.TABLE_NAME= px.TABLE_NAME
where t.TABLE_SCHEMA = 'database name' and px.COLUMN_KEY is null;