最近接了别人的项目,数据库的属性都有差异,所以统一查询了一下
select TABLE_NAME,COLUMN_NAME,DATA_TYPE,CHARACTER_SET_NAME,COLLATION_NAME,COLUMN_TYPE,COLUMN_COMMENT from INFORMATION_SCHEMA.Columns
where TABLE_SCHEMA='online_booking'
-- and (COLLATION_NAME in ('create_by','update_by') or COLUMN_COMMENT in ('创建者','更新者'))
and COLUMN_NAME in (select COLUMN_NAME from INFORMATION_SCHEMA.Columns
where TABLE_SCHEMA='online_booking'
group by COLUMN_NAME
having count(1)>1)
order by COLUMN_NAME desc;