ru compare the 2 null values?

Answers were Sorted based on User's Feedback



ru compare the 2 null values?..

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

ru compare the 2 null values?..

Answer / vignesh lakshmirajan

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

Post New Answer

More MySQL Interview Questions

What are the benefits of mysql?

1 Answers  


How do you know if your mysql server is alive?

1 Answers  


Can you tell which of the following where clauses is faster?

1 Answers  


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.

1 Answers  


How to show all records starting with the letters 'sonia' and the phone number '9876543210'

1 Answers  


What is the insert?

1 Answers  


What is blob storage?

1 Answers  


What is field in mysql?

1 Answers  


How does mysql store binary data?

1 Answers  


how to know the tables in database having foreign key?

2 Answers  


How many mysql connections can handle?

1 Answers  


What is mysql shell?

1 Answers  


Categories