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

Popular posts from this blog

Konfigurasi HTTPS (Berkualitas Tinggi) - Debian 8

Cara Instalasi dan Konfigurasi Briker