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

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....

A select query over a large table runs very slow because of the growing number of entries in that table. What different measures could be taken to improve speed?

5 Answers  

---

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

0 Answers  

---

What is schema in mysql?

0 Answers  

---

Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

3 Answers   TCS,

---

What is logs in mysql?

0 Answers  

---

What is the use of i-am-a-dummy flag in mysql?

0 Answers  

---

What is the maximum no of columns a table can have?

0 Answers  

---

What is the difference between mysql_fetch_array and mysql_fetch_object?

4 Answers   CTS,

---

How do I import database through command line?

0 Answers  

---

Is mysql server free?

0 Answers  

---

How to convert character strings to dates?

0 Answers  

---

How do I download a mysql community server?

0 Answers  

---