-
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
See if you like this:
SELECT TABLE_SCHEMA as db, TABLE_NAME, COLUMN_NAME,
CHARACTER_SET_NAME, COLUMN_TYPE
FROM `COLUMNS`
ORDER BY 3,4,5;
You might be able to embellish on it to avoid consistent definitions, etc.
-Original Message-
From: 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 that