Fid columns without primary or unique

SELECT t.TABLE_SCHEMA,t.TABLE_NAME,ENGINE FROM information_schema.TABLES t INNER JOIN information_schema.COLUMNS c ON t.TABLE_SCHEMA=c.TABLE_SCHEMA AND t.TABLE_NAME=c.TABLE_NAME AND t.TABLE_SCHEMA NOT IN ('performance_schema','information_schema','mysql') GROUP BY t.TABLE_SCHEMA,t.TABLE_NAME HAVING sum(if(column_key in ('PRI','UNI'), 1,0))=0;