mariadb get affected rows

From Onset Developer Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
mariadb get affected rows

Type: Function
Context: Server
Introduced: v1.0

NOTICE

This function is provided by the official MariaDB plugin.

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

Retrieved from "https://dev.playonset.com/index.php?title=mariadb_get_affected_rows&oldid=4275"