mysql - 比较mysql上的2个表结构

Question

此查询的作用是比较 mysql 上的 2 个表结构:

select column_name      ,max(case when table_name = 'table_1' then 'Yes' end) as in_table_1      ,max(case when table_name = 'table_2' then 'Yes' end) as in_table_2  from information_schema.columns where table_name in('table_1', 'table_2')   and table_schema = 'your_database' group    by column_name order    by column_name;

但是它将列名称转换为小型大写字母，有人知道如何调整它以比较混合小型和大写字母的列吗？

Answer 1

根据 MySQL manual :

"Column, index, stored routine, and event names are not case sensitive on any platform, nor are column aliases."