Modules/MTA-MySQL/mysql affected rows
Jump to navigation
Jump to search
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
int mysql_affected_rows ( MySQLConnection handler )
Required arguments
- handler: A valid MySQL link
Returns
The number of affected rows in the last query.
Example
Example 1: This example shows the number of deleted rows after deleting all accounts starting with 'A'
mysql_query(handler, "DELETE FROM account WHERE name LIKE 'A%'")
outputDebugString("We deleted a total of " .. mysql_affected_rows(handle) .. " accounts starting with 'A'")
See also
- mysql_connect
- mysql_close
- mysql_errno
- mysql_error
- mysql_ping
- mysql_select_db
- mysql_escape_string
- mysql_affected_rows
- mysql_change_user
- mysql_get_character_set_info
- mysql_get_client_info
- mysql_get_client_version
- mysql_get_host_info
- mysql_get_proto_info
- mysql_get_server_info
- mysql_get_server_version
- mysql_hex_string
- mysql_info
- mysql_insert_id
- mysql_query
- mysql_unbuffered_query
- mysql_set_character_set
- mysql_stat
- mysql_warning_count