Question

Which line of the following statements will produce error?

(a) SELECT * FROM person WHERE person_id=1;

(b) SELECT pname FROM person;

(c) SELECT pname, lname, person_id FROM person;

(d) None of the mentioned

I got this question in semester exam.

My query is from When Good Statements Go Bad in section Query Optimization of MySQL

Answer 1

Right answer is (d) None of the mentioned

To explain: None.