HI,
I have recently upgraded my mysql database to version 5.1.72 community log. I am having an issue that all my select queries are showing the columns as NULL if there is no entry added for a specific column. For exmaple I have a table table_employee and the employee name is entered as empty. When I run the select query and display the record it shows NULL instead of empty space. I am trying to get it fixed through my.ini settings in mysql. Is there any I can handle this through my.ini settings or do I have to put the conditions in my code for all the queries.
Thanks in advance
Saad_8 0 Newbie Poster
rproffitt 2,662 "Nothing to see here." Moderator
https://www.google.com/search?q=mysql+show+space+instead+of+NULL sees this is not a new issue and it's your choice to clean up the database or code as needed.
diafol
https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html#function_coalesce
COALESCE is supported by other DBMS as well as MySQL. IFNULL can also be used but it's specific to MySQL.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.