mysql命令行导出查询结果
SELECT * from test where time>'2019-10-28' into outfile '/opt/test.sql';
或者:
mysqldump -utest -p -c --default-character-set=utf-8 testdb testtable --where="time>'2019-10-28'" > /opt/test.sql
SELECT * from test where time>'2019-10-28' into outfile '/opt/test.sql';
或者:
mysqldump -utest -p -c --default-character-set=utf-8 testdb testtable --where="time>'2019-10-28'" > /opt/test.sql
mysql> source gkd.sql into outfile ddgkd.sql;