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 Calling Lua routines from SQL in the SQL Plus Lua section.box.execute– for making SQL statements callable from Lua functions. See the SQL user guide.box.prepareandbox.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 |