Scripting/Squirrel/Functions/mysql affected rows

Returns the number of changed rows (for UPDATE), inserted rows (for INSERT) or deleted rows (for DELETE) in the last query. For SELECT statements it works like mysql_num_rows.

Syntax

mysql_affected_rows ( MySQLConnection handler )

Arguments

• MySQLConnection handler - A valid MySQL link/handler

Return value

The number of affected rows in the last query.

Example

mysql_query(handler, "DELETE FROM account WHERE name LIKE 'A%'")
print("We deleted a total of " + mysql_affected_rows(handler) + " accounts starting with 'A'")

Related Functions

• mysql_affected_rows
• mysql_change_user
• mysql_close
• mysql_connect
• mysql_errno
• mysql_error
• mysql_escape_string
• mysql_fetch_assoc
• mysql_fetch_lengths
• mysql_fetch_row
• mysql_free_result
• mysql_info
• mysql_insert_id
• mysql_num_fields
• mysql_num_rows
• mysql_ping
• mysql_query
• mysql_select_db
• mysql_warning_count