Interested in improving this site? Please check the To Do page.

Back to MySQL Verbs

mysql.getQueryInfo

Get a string summarizing results of last query (if insert, update, delete).

Syntax

mysql.getQueryWarningCount(dbid)

Params

A database connection ID.

Be careful – it’s natural to assume you’re going to pass a query ID, but you need to be sure to pass a database connection ID instead.

Returns

A string containing information about the query in human-recognizable form

Examples

count = mysql.getQueryInfo(id)

Notes

This function returns result data only for certain queries of the form:

  • INSERT INTO ... SELECT ...
  • INSERT INTO ... VALUES (...),(...),(...)...
  • LOAD DATA INFILE ...
  • ALTER TABLE
  • UPDATE

For all others, the routine returns “”

Be careful – it’s natural to assume you’re going to pass a query ID, but you need to be sure to pass a database connection ID instead.

See Also


Personal Tools