SELECT colname INTO OUTFILE "~/outfile.csv" FIELDS TERMINATED BY ',' FROM table;
09. 02. 23 added
mysql db의 user권한 중 파일 핸들링 가능토록 조정
$ mysql -uroot -pxxxx mysql
update user set File_priv='Y' where user='userid';
flush privileges;
-------------------------
echo "SELECT columns FROM table_name WHERE whatever='something'" | /path/to/mysql -uUSERNAME -pPASSWORD DATABASENAME > /tmp/outfile.txt; 
금지!
Posted by ⓒ쟁이™
