Column Details in Mysql

select a.Table_schema,a.table_name,a.Column_name,a.data_type,a.column_type,b.table_type from information_schema.columns a inner join information_schema.tables b on a.table_name = b.table_name 
where a.table_schema in();