ru compare the 2 null values?
Answers were Sorted based on User's Feedback
Answer / 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 |
IMPOSSIBLE...!!!!
WE CAN'T COMPARE TWO NULL VALUES
COZ NULL MEANS "THE VALUE IS UNKNOWN";
SO WE CANT COMPARE THE UNKNOWN VALUES....
| Is This Answer Correct ? | 0 Yes | 0 No |
How to load data from a text file into a table?
Can we join 3 tables in mysql?
What does do in mysql?
What is meant by decimal (5,2)?
How can we get total number of records by query in mysql?
How do I find the database name in mysql?
What is ntext?
How to set mysql variable in php?
What are different TEXT data types in MySQL?
How do I tune a mysql query?
Can you tell few best practices to be followed for optimization in sql?
What is mysql and why it is used?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)