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 |
What are the benefits of mysql?
How do you know if your mysql server is alive?
Can you tell which of the following where clauses is faster?
For the database from the previous question, please give an SQL query which returns the invoice number of all invoices which contain the article with the number ?1234?. The query should be able to run under a MySQL 4.0 database.
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
What is the insert?
What is blob storage?
What is field in mysql?
How does mysql store binary data?
how to know the tables in database having foreign key?
How many mysql connections can handle?
What is mysql shell?
Oracle (3253)
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)