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
How do I find mysql version in mysql workbench?
What are the advantages of mysql?
What is a longblob?
How do I know if mysql is installed on windows?
Why to use char instead of varchar in the database?
How to shut down the server with 'mysqladmin'?
What is mysql and how it works?
What are the advantages of mysql in comparison to oracle?
What is row level locking in mysql?
What is mysql primary key?
What is database in php mysql?
Where is the mysql database stored?
What is an example of a delimiter?
How many rows can mysql hold?
Which statement is used in a select query for partial matching?