Last answered:

22 Jul 2024

Posted on:

22 Jul 2024

0

IS NOT NULL query getting null values

 Hi Team,

On running the below query i am able to the get the null values also. I guess the output should not have nulls. Can you please help me modify the code?

1 answers ( 0 marked as helpful)
Instructor
Posted on:

22 Jul 2024

0

Hi Rahul!
Thanks for reaching out.


In MySQL Workbench, seeing a row of NULL values at the end of every query result is normal. It's designed this way to allow you to easily add new rows. When you start typing in the NULL row, it creates a new row in your table. This feature makes it convenient to add data directly through the interface.


Hope this helps.
Best,
Tsvetelin

Submit an answer