1, Login to mysql terminal:
c@cm-test:~$ mysql -u xxxxxx -pxxxxxxx mydatabase
2, run:
mysql> select * into OUTFILE 'abc.CSV' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM excel_unique;
3, the file should be in
/mydisk/lib/mysql/mydatabase/abc.CSV
SELECT Email INTO OUTFILE '/tmp/contact.CSV' FIELDS TERMINATED BY ','
ReplyDeleteOPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'
FROM `all_suppliers` WHERE email !='';
SELECT DISTINCT(Email) INTO OUTFILE '/tmp/contact.CSV' LINES TERMINATED BY '\n'
ReplyDeleteFROM `all_suppliers` WHERE email !='';