通过mysql select outfile 配合IFNULL导出数据

SELECT id,IFNULL(name,'') name into outfile "D:\\temp\\demo2.txt"  fields terminated by "\t" lines terminated by '\r\n' 
from demo;

来源：https://blog.csdn.net/shenliang1985/article/details/89955645