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 much does mysql enterprise cost?
What is a tinyint?
what is the difference between between and in operators in mysql?
What is truncate in mysql?
How to Join tables on common columns.
How can you calculate the sum of any column of a table?
what is a cursor? : Mysql dba
What is the purpose of -> in the mysql terminal?
What is clob in mysql
How will you export tables as an xml file in mysql?
What is a join? Explain the different types of mysql joins.
What is row?
How to display odd rows in student table in mysql?
What is row locking in mysql?
How to use 'mysql' to run sql statements?