mysql -h host --user=user --password=password -D database -B -e "query sql" | sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" > content.csv
如:
mysql -h 172.0.0.1 --user=root --password=abc123 -D content -B -e "select id,content from table_1 limit 100;" | sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" > content.csv
MySQL 查询数据并导出为 csv
于 2023-11-13 14:55:15 首次发布