MySQL两个表重复值查询

对比all_table_column_mysql和all_table_column_oracle

SELECT table_name,column_name
, data_type,column_len 
FROM (
SELECT * FROM all_table_column_mysql
UNION ALL
SELECT table_name,column_name
, data_type,column_len 
from all_table_column_oracle) c 
GROUP BY c.table_name
HAVING COUNT(*)=1 
ORDER BY c.table_name ;