mariadb get affected rows: Difference between revisions
From Onset Developer Wiki
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
{{Notice|This function is provided by the official [[MariaDB]] plugin.}} | {{Notice|This function is provided by the official [[MariaDB]] plugin.}} | ||
{{FuncDescription|Returns the number of affected rows if the query was a CRUD query.}} | {{FuncDescription|Returns the number of affected rows if the query was a CRUD (Create, read, update and delete) query.}} | ||
{{FuncSyntax|mariadb_get_affected_rows()}} | {{FuncSyntax|mariadb_get_affected_rows()}} | ||
| Line 12: | Line 12: | ||
== Example == | == Example == | ||
<syntaxhighlight lang="Lua> | <syntaxhighlight lang="Lua"> | ||
function UpdateVehicles() | |||
local query = mariadb_prepare(sql, "UPDATE vehicles SET owner = 0 WHERE model = 34;") | |||
mariadb_async_query(sql, query, OnUpdateVehicles) | |||
end | |||
function OnUpdateVehicles() | |||
local affected_rows = mariadb_get_affected_rows() | |||
print("Number of vehicles updated: ", affected_rows) | |||
end | |||
</syntaxhighlight> | </syntaxhighlight> | ||
{{RelatedFunctions}} | {{RelatedFunctions}} | ||
{{Template:MariaDBFunctions}} | {{Template:MariaDBFunctions}} | ||
Latest revision as of 08:50, 2 September 2020
Description
Returns the number of affected rows if the query was a CRUD (Create, read, update and delete) query.
Syntax
mariadb_get_affected_rows()
Parameters
- This function has no parameters.
Return Value
- Number of affected rows. false on error.
Example
function UpdateVehicles()
local query = mariadb_prepare(sql, "UPDATE vehicles SET owner = 0 WHERE model = 34;")
mariadb_async_query(sql, query, OnUpdateVehicles)
end
function OnUpdateVehicles()
local affected_rows = mariadb_get_affected_rows()
print("Number of vehicles updated: ", affected_rows)
end
See also
- OnQueryError
- mariadb_log
- mariadb_connect
- mariadb_connect_file
- mariadb_close
- mariadb_unprocessed_queries
- mariadb_async_query
- mariadb_query
- mariadb_await_query
- mariadb_query_file
- mariadb_await_query_file
- mariadb_errno
- mariadb_error
- mariadb_escape_string
- mariadb_prepare
- mariadb_set_charset
- mariadb_get_charset
- mariadb_stat
- mariadb_get_row_count
- mariadb_get_field_count
- mariadb_get_result_count
- mariadb_get_field_name
- mariadb_set_result
- mariadb_get_value_index
- mariadb_get_value_index_int
- mariadb_get_value_index_float
- mariadb_get_value_name
- mariadb_get_value_name_int
- mariadb_get_value_name_float
- mariadb_save_result
- mariadb_delete_result
- mariadb_set_active_result
- mariadb_unset_active_result
- mariadb_is_any_result_active
- mariadb_is_valid_result
- mariadb_get_affected_rows
- mariadb_get_warning_count
- mariadb_get_insert_id
- mariadb_get_query_exec_time
- mariadb_get_query_string
- mariadb_get_row
- mariadb_get_assoc
