Interested in improving this site? Please check the To Do page.
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.