列出共享完全相同列名的所有表

I am somewhat of a novice to SQL, but have been playing around with it using SQLFiddle to get better at it. What if you wanted to find and list all the tables that have common columns or columns that are shared across the different tables (e.g. table 1, 2, 3, & 4 have a customer field, while table 2 & 4 have a student field? How would you do that with MySQL? Lets say you have 100+ tables and not 2.I am somewhat of a novice to SQL, but have been