CODEWITHSUNDEEP
mysql
Gambit2007
Gambit2007

Reputation: 4014

MySQL - how to export CSV with NULL values as empty?

Right now i use MySQLWorkbench to export a CSV file but if the field as a NULL values it's getting exported as:

value1, /N, value2, /N, /N

How can i make sure it's exported as: value1, , value2, ,

?

Upvotes: 0

Views: 1981

Answers (1)

Krish
Krish

Reputation: 5917

You can use coalesce(FieldName,'') to return empty string instead of Null

Upvotes: 2

Related Questions