Cacher is the code snippet organizer for pro developers

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 '';