Export mysql data entry into text file
Sometime we need to export mysql table into text file for fast print out, here comes the command
SELECT nama-kolom FROM nama-tabel INTO OUTFILE '/tmp/nama-file.txt' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';
Comments
Post a Comment