Mysql导入、导出CSV——将NULL转化为空字符串''

• 导出CSV

第一种方法是在sql语句里进行处理：

利用mysql语法：IFNULL(expr1,'') expr1为要查的属性。

第二种方法 JAVA set，get方法：

• 导入CSV:

LOAD DATA infile '/test.txt'

INTO TABLE moo

fields

terminated BY ","

lines terminated BY "\n"

IGNORE 1 LINES

(@vone, @vtwo, @vthree, @vfour, @vfive)

SET

one = nullif(@vone,''),

two = nullif(@vtwo,''),

three = nullif(@vthree,''),

four = nullif(@vfour,'')