mysql导出csv格式命令

mysql -h 127.0.0.1 -u user -p123456 -Bse "select name,age from user where age > 10;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > /tmp/user.csv

posted @ 2020-02-26 16:09  KylinStayHere  阅读(448)  评论(0编辑  收藏  举报