SELECT
*
FROM
(SELECT
TABLE_SCHEMA, TABLE_NAME, COUNT(COLUMN_KEY) AS count_pri_col
FROM
information_schema.COLUMNS
WHERE
COLUMN_KEY = 'PRI' and TABLE_SCHEMA not in ('mysql')
GROUP BY TABLE_SCHEMA , TABLE_NAME) AS aa
WHERE
aa.count_pri_col > 1;