ZCE # Week # 53

Question: 

Which of following functions is not a valid MySQL function?

A. mysql_ping()
B. mysql_data_seek()
C. mysql_field_seek()
D. mysql_stats()

Explanation:

  • mysql_ping() -- Ping a server connection or reconnect if there is no connection. Checks whether or not the connection to the server is working. If it has gone down, at automatic reconnection is attempted.  **Automatic reconnection is disabled by default in version of MySQL >= 5.0.3.
  • mysql_data_seek() -- Move internal result pointer of the MySQL result associated with the specified result identifier to point to the specified row number.
  • msyql_field_seek() -- Set result pointer to a specified field offset. If the next call to mysql_fetch_field() doesn't include a field offset, the field offset specified in mysql_field_seek() will be returned.
  • mysql_stats() is not a valid function.

** But there is a function named mysql_stat() which returns the current server status.

Answer:  D