lua
box.schema.space.create('my_table')
local my_table = box.schema.space['my_table']
my_table:format({
{name = 'id', type = 'integer'},
{name = 'name', type = 'string'},
{name = 'age', type = 'integer'}
})
my_table:create_index('primary', {
type = 'hash',
parts = {'id'},
unique = true
})
lua
local result = my_table.index.primary:select({id = 1})
for _, tuple in ipairs(result) do
print(tuple)
end
yaml
box:
memtx_memory: 100MB
vinyl_memory: 200MB
wal_mode: write
checkpoint_interval: 3600
index:
- space: my_table
name: primary
type: TREE
unique: true
parts: [0, 'integer']
