output to file in mysql
select `TABLE_NAME`,`COLUMN_NAME`,`ORDINAL_POSITION`,`COLUMN_DEFAULT` from information_schema.columns where TABLE_SCHEMA = 'hhims' order by TABLE_NAME into outfile 'd:\del.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '';