mysql命令行导出查询结果

  sre
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

One Reply to “mysql命令行导出查询结果”

LEAVE A COMMENT

Captcha Code