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)
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