需要把特定条件的查询结果导出为sql
1.在登录后:使用into outfile
select * into outfile ‘/bak/uc_members_out.sql’ from uc_members_tmp where username not in (select username from uc_members);
此方法可能无法执行
2.使用shell:但也要有相应的权限
mysqldump -h192.168.1.2 -uroot -p –where=’username not in (select username from uc_server_tmp.uc_members)’ –skip-lock-tables uc_server_tmp uc_members_tmp >m.sql;
此处有两个参数一定要写:
一个是”–where”,条件语句
一个是”–skip-lock-tables”,跳过锁表,没有此参数,会导不出数据
3.导出csv文件:
导出文件后加上参数:fields terminated by ‘,’ optionally enclosed by ‘\”‘ escaped by ‘\”‘ lines terminated by ‘\r\n'”
如果列值有NULL出现,格式会乱,可以不用“\“”来关闭字段,
还可参考:https://zhidao.baidu.com/question/2203613094125969868.html