Monday, August 31, 2015
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';
;