Export SQL to Excel - handling nulls When I run this plug-in with SQL

paule over 8 years ago

Export SQL to Excel - handling nulls

When I run this plug-in with SQL of the form "SELECT * FROM ...", any NULL value in the source table are converted to spaces (blanks) in the CSV file. Is there a way to produce NULL in the CSV file? Do I have to specify each field in the table and use the IFNULL function? (I am using a MySQL database)

Discussion posts and replies are publicly visible

0 Sumeet Khare over 8 years ago

If you want to show different values other than blanks then you need to use IFNULL in your query.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel