Database.exec(sql)


Execute the provided SQL statement.

Parameters

sql

A string that contains a SQL statement.

Notes

Return value

Returns the result of the SQL statement as rows (each row is represented as a Lua table with column names as keys) or nil if there is no result.

Example

local sqlite = require "sqlite" -- Create an in-:memory: database local db = sqlite.Database(":memory:") -- Create a new table "users" db:exec([[CREATE TABLE users ( id integer PRIMARY KEY, name text NOT NULL, age integer)]]) -- Insert a new row db:exec("INSERT INTO users (name, age) VALUES(?, ?)", "John", 32) -- Get a row from the SELECT statement local row = db:exec("SELECT * FROM users WHERE(name == 'John')") print(row.name, row.age)