Thursday, January 20, 2011

dump mysql table to csv file

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
at

2 comments:

  1. Tech NotesFebruary 15, 2012 at 12:35 PM

    SELECT Email INTO OUTFILE '/tmp/contact.CSV' FIELDS TERMINATED BY ','
    OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'
    FROM `all_suppliers` WHERE email !='';

    ReplyDelete
  2. Tech NotesFebruary 15, 2012 at 12:42 PM

    SELECT DISTINCT(Email) INTO OUTFILE '/tmp/contact.CSV' LINES TERMINATED BY '\n'
    FROM `all_suppliers` WHERE email !='';

    ReplyDelete

Subscribe to: Post Comments (Atom)