mysql -h dbreport100.it-prod.dus1.cloud --user=jinwan --password -B -e "select aa.* from (select premium_user_category.user_id,email,premium_user_profile.phone_number,premium_user_profile.last_post_activated ,premium_user_profile.LAST_MODIFIED_ON from ean_9.premium_user_category join ean_9.user on ean_9.premium_user_category.user_id=user.id left join ean_9.premium_user_profile on user.id=premium_user_profile.user_id group by user_id) as aa;" | sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" > user_glen1.csv
scp -r jinwan@shellserver100.it-prod.ams1.cloud:/tmp/user_glen1.csv /Users/jinwan
===========================
mysql导出csv并且从服务器下载到本地
最新推荐文章于 2024-09-12 01:15:37 发布