Mega Code Archive

 

Categories / MySQL / Backup Load

 

To export the passwd table in CSV format with CRLF-terminated lines, use this statement

SELECT * FROM passwd INTO OUTFILE '/tmp/passwd.txt' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n';