V

Vijay Sangwan • 28.62K Points
Instructor II

Q. What will be the output of the following MySQL command?
SELECT *
FROM person
WHERE emp_id = NULL;

  • (A) Only those columns whose emp_id is NULL
  • (B) Only those columns whose emp_id is not NULL
  • (C) No output
  • (D) None of the mentioned
  • Correct Answer - Option(C)
  • Views: 15
  • Filed under category MySQL
Explanation by: Vijay Sangwan 
This question is about how MySQL handles NULL values in a WHERE clause.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Question analytics