nanos world API Reference Unofficial documentation
Italiano
Official documentation
Function Server

Database:Execute

Execute a query synchronously

Syntax

Lua 
my_database:Execute(query, parameters... = nil)

Parameters

Name Type Default Description
query string — Query to execute
parameters... optional any nil Sequence of parameters to escape into the Query

Returns

  • integer affected rows
  • string error (if any)

Examples

Inserts into database (SQLite) 
local affected_rows = my_database:Execute("INSERT INTO MyTable VALUES (:0, ':1')", 123, "MyValue")