Thursday, August 13, 2015

Save Mysql table -> field, type, comment to csv

Mysql statement to save table field, type, comment to csv
SELECT
 
    column_name,
    column_type,
    column_default,
    column_comment
 
FROM information_schema.columns
WHERE table_name='c_product_detail'
INTO OUTFILE 'C:/Users/Imran/Desktop/work/table.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';
;