CSV 匯出匯入

CSV 匯入

• http://chensh.loxa.edu.tw/php/X_21.php
• http://dev.mysql.com/doc/refman/5.0/...sqlimport.html
• http://forums.mysql.com/read.php?108,212918,212918
• http://www.linuxquestions.org/questi...script-781812/
• http://ericlondon.com/bash-shell-scr...sv-files-mysql
• Script to import Master.csv in the MySQL database
• http://codingstandards.iteye.com/blog/604541

CSV 匯出

直接使用 mysql 外部指令導出結果，並格式化為 CSV

mysql -uroot -pThisispassword -e "select date(logtime) as day, count(*) as rows from syslog" syslog | tr '\t' ',' > syslog_rows.csv