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 are the technical features of MySQL?
How do I clear a mysql database?
How do I change directories in mysql?
Can you tell a way to know the number of days between the two given dates in php?
How to set the time zone for MySQL to particular country time?
What are the limitations of mysql?
explain GROUPBY & HAVING clause with examples.
How can you add and remove any column of a table?
Can we rollback truncate in mysql?
What mysql -u john -p command does?
Can you tell the difference between mysql_fetch_object and mysql_fetch_array?
Are stored procedures precompiled?
What is query design?
How to delete a table.
What are procedures in mysql? Explain
