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
Why do we use preparedstatement?
What is query design?
How to create a new view in mysql?
How to install mysql?
What is data node in mysql cluster?
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
Why mysql is so popular?
What is unsigned int in mysql?
How can you validate emails using a single query?
Can we rollback truncate in mysql?
How to delete a database from mysql server.
What are the 3 main types of search queries?
What is a heap table?
What are the indexes in mysql?
Is blocked because of many connection errors unblock with mysqladmin flush hosts?