RE: Need query to determine different column definitions across tables

2013-07-09 Thread Rick James
- From: Daevid Vincent [mailto:dae...@daevid.com] Sent: Monday, July 08, 2013 7:57 PM To: mysql@lists.mysql.com Subject: RE: Need query to determine different column definitions across tables -Original Message- From: Daevid Vincent [mailto:dae...@daevid.com] Sent: Monday, July

Need query to determine different column definitions across tables

2013-07-08 Thread Daevid Vincent
I'm noticing that across our several databases and hundreds of tables that column definitions are not consistent. I'm wondering if there is a tool or query (using INFORMATION_SCHEMA perhaps) that will show me all databases, tables and columns where they don't match (by column name). For example

RE: Need query to determine different column definitions across tables

2013-07-08 Thread Rick James
...@daevid.com] Sent: Monday, July 08, 2013 2:11 PM To: mysql@lists.mysql.com Subject: Need query to determine different column definitions across tables I'm noticing that across our several databases and hundreds of tables that column definitions are not consistent. I'm wondering

RE: Need query to determine different column definitions across tables

2013-07-08 Thread Daevid Vincent
-Original Message- From: Daevid Vincent [mailto:dae...@daevid.com] Sent: Monday, July 08, 2013 2:11 PM To: mysql@lists.mysql.com Subject: Need query to determine different column definitions across tables I'm noticing that across our several databases and hundreds of tables