mysql按照条件导出数据

mysqldump条件导出

mysqldump -h127.0.0.1 -uadmin -padmin -t dbName tableName --where="number is null and add_date<=1539691917000 and add_date>=1534420881000;" --triggers=false --replace > test.sql

mysqldump -uadmin -p123456 dbName > out_db_name