Daily Archive for June 7th, 2010

MySQL output pipe to file

Published on June 7, 2010 18:53 Tags: , . 
1

SELECT password FROM vb_user INTO OUTFILE '/tmp/pwds.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';