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
πŸ’¬ Discuss
βœ… Correct Answer: (C) No output
Explanation: This question is about how MySQL handles NULL values in a WHERE clause.
Explanation by: Vijay Sangwan
This question is about how MySQL handles NULL values in a WHERE clause.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
86
Total Visits
πŸ“½οΈ
1 y ago
Published
πŸŽ–οΈ
Vijay Sangwan
Publisher
πŸ“ˆ
86%
Success Rate