Answer Posted / prathiba
U can compare the two null values, by using these operators
IS NULL: operator returns true of column value is NULL.
IS NOT NULL: operator returns true of column value is not
NULL.
<=> operator compare values, which (unlike the = operator)
is true even for two NULL values
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the innodb in mysql?
How to include numeric values in sql statements?
What is the maximum size of table in mysql?
What is the difference between a heap table and temporary table?
Is mysql better than oracle?
What is the usage of regular expressions in mysql?
How to present a past time in hours, minutes and seconds?
what is mysql optimization in brief?
What does mysql flush hosts do?
How to get last inserted id after insert data from a table in mysql?
Is mysql case-sensitive?
How do we use % when performing a search query?
How to start mysql server?
How to write date and time literals?
Where does mysql store data?