mysql into outfile NULL

[yehlu]

https://www.reddit.com/r/mysql/comments ... t_null_as/

you can select ifnull(my_column, "") to turn it into "" at the select.

[yehlu]

代碼: 選擇全部

SELECT * INTO OUTFILE 'CUSTOMER.CSV' FIELDS TERMINATED BY ',' from SUNRISECT.CUSTOMER limit 0,10;

代碼: 選擇全部

sed -i 's/\\N/\ /g' CUSTOMER.CSV