title: How to handle null field when exporting MYSQL tables to CSV
body: <p>Right now when I export MYSQL tables to CSV files, I'm getting \N for NULL fields in the database which is expected. If there a way to change the \N output to just an empty string when exporting tables to csv?</p>
  
  <p>Thanks</p>
  
  <pre><code>SELECT 'CU_CustomerID','CU_UserName','CU_Password','CU_Email','CU_Company','CU_Comment','CU_LastBasket','CON_FirstName','CON_MiddleI','CON_LastName','CON_Address1','CON_Address2','CON_City','CON_State','CON_Province','CON_Country','CON_Zip','CON_Phone1','CON_Phone2'
  UNION
  SELECT T1.CU_CustomerID,T1.CU_UserName,T1.CU_Password,T1.CU_Email,T1.CU_Company,T1.CU_Comment,T1.CU_ShopperPoints,T2.CON_FirstName,T2.CON_MiddleI,T2.CON_LastName,T2.CON_Address1,T2.CON_Address2,T2.CON_City,T2.CON_State,T2.CON_Province,T2.CON_Country,T2.CON_Zip,T2.CON_Phone1,T2.CON_Phone2
  FROM CUSTOMERS AS T1
  INNER JOIN CONTACT AS T2 ON T1.CU_CustomerID = T2.CON_CustomerID
  WHERE T1.CU_CustomerID BETWEEN 0 AND 1000
  INTO OUTFILE  'customers.csv'
  FIELDS TERMINATED BY  ','
  ENCLOSED BY  '"'
  </code></pre>