mysqldump 并没有这样的功能,--ignore-table是忽略其中的某些表,而不是表中的某些记录.如果要过滤表中的某些记录,只能是先用SQL语句得到你想要的结果集,再将这个结果集导出.
select * into outfile "C:/backup.txt" fields terminated by ',' enclosed by '"' lines terminated by '\r\n' from table where condition
select * into outfile "C:/backup.txt" fields terminated by ',' enclosed by '"' lines terminated by '\r\n' from table where condition
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货