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

Where’s database data actually stored?

0 Answers  

---

What is default password for mysql?

0 Answers  

---

Is mysql deprecated?

0 Answers  

---

What are different TEXT data types in MySQL?

1 Answers  

---

What is unique key in mysql?

0 Answers  

---

---

I want to make a query where I want to eliminate the duplicate rows from the table. For example : Input : Table : NAME Column1 Column2 India USA USA India UK India India UK The desired output that I want to eliminate the duplicates Output India USA UK India Thanks

2 Answers   Sun Life,

---

How to show certain selected rows with the value "pcds".

0 Answers  

---

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

0 Answers  

---

How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

0 Answers  

---

Is mysql port 3306 tcp or udp?

0 Answers  

---

explain GROUPBY & HAVING clause with examples.

0 Answers  

---

What is different between sql and mysql?

0 Answers  

---