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

Back to MySQL Verbs

mysql.getAffectedRowCount

After a query, returns the number of rows changed, deleted, or inserted.

Syntax

mysql.getAfffectedRowCount(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 double-value (the number of rows could be very high)

Examples

count = mysql.getAffectedRowCount(id)

Notes

Returns the number of rows changed (for UPDATE), deleted (for DELETE), or inserted (for INSERT). For SELECT statements, works like mysql.getSelectedRowCount().

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