将MySQL的执行结果导出到csv文件

mysql -A db_name -h host_name -u user_name -p -ss -e "SELECT * FROM table_name LIMIT 100;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > logs.csv

参考链接：https://www.cnblogs.com/tommy-huang/p/9417090.html