CodeCharge TAIWAN

發表於 : **2018-05-11 20:48:29**

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

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

發表於 : **2018-05-11 20:57:39**

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

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

mysql into outfile NULL