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 drop an existing table in mysql?
Create table employee (eno int(2),ename varchar(10)) ?
How to set the time zone for MySQL to particular country time?
How can we change the data type of a column of a table?
Is microsoft sql same as mysql?
How do I clear the command in mysql?
Where’s database data actually stored? Is there a way to see the files which are stored?
Can you tell a way to know the number of days between the two given dates in php?
How can you change the name of any existing table by using the sql statement?
How do I install and use mysql?
How would you get the current date in mysql?
What is mysql ndb?
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)