Mysql select null as empty string

We will be going through examples to demonstrate the same. We will get started by making the sample data to be used across the examples.

The sample data includes creating a table named studentDetails and inserting some rows; a few column values will be inserted as NULL. Therefore let us look into the syntax of the same:. What will happen if we execute the below query? Good Luck!!!. Nemes M. Nemes 49 1 1 silver badge 4 4 bronze badges.

SenorAmor SenorAmor 3, 14 14 silver badges 27 27 bronze badges. This is filtering the output which i dont think the OP is after — Simon. This is my solution based on his example. I don't really see the reason blank lines would be more professional than NULL values.

Daniel Daniel 1 2 2 silver badges 1 1 bronze badge. I didn't understand the question very well, sorry!! Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked 0. Related Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.

The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked 0. Related Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled.