Question

Which of these returns a string containing an error message?

(a) mysql_error()

(b) mysql_errno()

(c) mysql_sqlstate()

(d) mysql_close()

The question was asked during an interview.

My question is taken from Handling Errors and Processing Command Options topic in division MySQL Programs Using C of MySQL

Answer 1

The correct answer is (a) mysql_error()

To elaborate: The API call named ‘mysql_error()’ returns a string containing an error message. ‘mysql_close()’ does not return any value at all. ‘mysql_errno()’ returns a MySQL-specific numeric code.