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

How can you do the fine tunning?

3 Answers   ACC,


What does tinyint mean?

0 Answers  


List data types in mysql? Explain

0 Answers  


How do I restore a mysql database dump file in linux?

0 Answers  


How to make a copy values from one column to another in mysql?

0 Answers  






What is a trigger in mysql?

0 Answers  


Explain timestamp?

0 Answers  


date funciton

2 Answers  


What is the use of concat() in mysql?

0 Answers  


how many fields can be updated using set in a mysql query?

1 Answers  


Explain MySQL architecture?

1 Answers  


What does "i_am_a_dummy flag" do in mysql?

0 Answers  


Categories