about billson
Gathering & Sharing
2013-07-31
MySql Select statement export to a file.
SELECT column_a, column_b, column_c FROM tb_abc INTO OUTFILE 'C:/folders/location/tb_abc.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)
Google Referrals