运行-CMD
MYSQL -U 用户名 -P 密码
一、mysql 导出部分字段
mysql -uroot -proot pgenius -e " select 'INNER_CODE','FUND_CODE' union SELECT INNER_CODE,FUND_CODE from FND_GEN_INFO where ctime>='2016-6-16' and ISVALID=1 INTO OUTFILE 'd:/datadata/FND_GEN_INFO11.sql'";
mysql -uroot -proot pgenius -e " select 'INNER_CODE','FUND_CODE' union SELECT INNER_CODE,FUND_CODE from FND_GEN_INFO_HIST where ctime>='2016-6-16' and ISVALID=1 INTO OUTFILE 'd:/datadata/FND_GEN_INFO_HIST11.sql'";
多表之前用分号隔开
二、mysql 导入部分字段