mysql导出csv并且从服务器下载到本地

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



===========================