Tarantool CE/EE Documentation portal logo
Support

Functions for SQL

The box module contains some functions related to SQL:

  • box.schema.func.create — for making Lua functions callable from

SQL statements. See [ссылка](../../../reference_sql/sql_plus_lua#sql_calling_lua )

in the SQL Plus Lua section.

  • box.execute — for making SQL statements callable from Lua functions. See the SQL user guide.
  • box.prepare and box.unprepare.

Some SQL statements are illustrated in the SQL tutorial.

Below is a list of all SQL functions and members.

Name

Use

box.execute()

Make Lua functions callable from SQL statements. See Calling Lua routines from SQL in the SQL Plus Lua section

box.prepare()

Make SQL statements callable from Lua functions. See the SQL user guide

object prepared_table

Methods for prepared SQL statement