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 to load data files into tables with 'mysqlimport'?
What is sqlyog?
SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?
What is the latest mysql?
What is the current mysql version?
Is primary key auto increment?
How do I insert an image into mysql workbench?
What is the insert?
How to concatenate two character strings?
Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.
What are the steps required to view your mysql database?
Can you tell the difference between $message and $$message?
What happens if you no create privilege in a database?
What is csv?
What is difference between group by and order by clause?
