按条件导出Excel
mysql -uyqcloud_user -p123456 -h xxx.su.baidubce.com biz-km -P 3306 -e "select * from km_security_level where iam_organization_id = 31" > ~/Desktop/export1.xlsx
按条件导出sql
mysqldump -uyqcloud_user -p123456 -P 3306 --set-gtid-purged=OFF -h mysql57.xxx.baidubce.com biz-km km_security_level --where="iam_organization_id = 31" > ~/Desktop/export2.sql
注意:
- -p和pwd没有空格
- sql中不可写select所有字段且不可更改
- sql只写where条件部分,且不能联合查询