Question

Which of the following returns a MySQL-specific numeric code?

(a) mysql_error()

(b) mysql_errno()

(c) mysql_sqlstate()

(d) mysql_close()

The question was posed to me during an interview.

The origin of the question is Handling Errors and Processing Command Options in division MySQL Programs Using C of MySQL

Answer 1

The correct option is (b) mysql_errno()

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