Scripting/Squirrel/Functions/mysql affected rows: Difference between revisions
Jump to navigation
Jump to search
This wiki is using an old backup from 2020
Some information may be old/missing
(Created page with "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....") |
m (Do not sign your edits) |
||
| Line 13: | Line 13: | ||
<pre>mysql_query(handler, "DELETE FROM account WHERE name LIKE 'A%'") | <pre>mysql_query(handler, "DELETE FROM account WHERE name LIKE 'A%'") | ||
print("We deleted a total of " + mysql_affected_rows(handler) + " accounts starting with 'A'")</pre> | print("We deleted a total of " + mysql_affected_rows(handler) + " accounts starting with 'A'")</pre> | ||
Revision as of 03:36, 10 March 2016
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'")