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 a tinyint?
What are procedures in mysql?
Can we store videos in mysql database?
How can you increase the performance of mysql select query?
What is difference between inner vs self vs cross?
what is constraints?
What are the 3 main types of search queries?
What is the usage of ENUMs in MySQL?
write a command to view the content of the table
What is the storage engine for mysql?
What is index length in mysql?
What is mysql data directory?
How to make a copy values from one column to another in mysql?
Where the database is stored in mysql?
What is not null in mysql?
