Scripting/Squirrel/Functions/mysql affected rows: Difference between revisions

From Vice City Multiplayer
Jump to navigation Jump to search
Caution icon
This wiki is using an old backup from 2020
Some information may be old/missing
m (Do not sign your edits)
No edit summary
 
(One intermediate revision by the same user not shown)
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>
== Related Functions ==
{{Scripting/Squirrel/Functions/MySQL Functions}}
[[Category:Scripting/Squirrel/Functions/Mysql_Functions]]

Latest revision as of 18:27, 30 January 2017

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