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