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

Is there a free version of mysql?

0 Answers  


Can we store videos in mysql database?

0 Answers  


How many tables will create when we create table, what are they?

2 Answers  


What is the maximum connection pool size?

0 Answers  


How to load data files into tables with 'mysqlimport'?

0 Answers  






What is database clustering in mysql?

0 Answers  


What is truncate command?

0 Answers  


What is a left join mysql?

0 Answers  


What is a trigger? How you can create a trigger in mysql?

0 Answers  


can you tell how can you display the maximum salary in sql? : Mysql dba

0 Answers  


What is myisam?

0 Answers  


What is the difference between char and varchar in mysql?

0 Answers  


Categories