mariadb get affected rows

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