SELECT mm.table_name,
group_concat(mm.column_name)
FROM
(
SELECT table_name,COUNT(1)
FROM
INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE constraint_name = 'PRIMARY'
GROUP BY table_name
HAVING COUNT(1) >1
) tt LEFT JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE
mm ON tt.table_name = mm.table_name and mm.constraint_name = 'PRIMARY' group by mm.table_name