Zen

Source string Source string

162/10000 · 162
English Actions
SQL tutorial
This tutorial is a demonstration of the support for SQL in Tarantool. It includes the functionality that you'd encounter in an "SQL-101" course.
Starting up with a first table and SELECTs
Initialize
In this tutorial, the requests are done in the Tarantool interactive console. Start Tarantool and initialize it with :ref:`default settings <box_introspection-box_cfg>` by calling ``box.cfg{}``:
tarantool> box.cfg{}
Now you can start working with the database.
Switch to the SQL language
A feature of the client console program is that you can switch languages and specify the end-of-statement delimiter.
Run the following commands to set the console input language to SQL and use semicolon as a delimiter:
tarantool> \set language sql
tarantool> \set delimiter ;
CREATE, INSERT, UPDATE, SELECT
To get started, enter simple SQL statements:
CREATE TABLE table1 (column1 INTEGER PRIMARY KEY, column2 VARCHAR(100));
INSERT INTO table1 VALUES (1, 'A');
UPDATE table1 SET column2 = 'B';
SELECT * FROM table1 WHERE column1 = 1;
The result of the ``SELECT`` statement looks like this:
tarantool> SELECT * FROM table1 WHERE column1 = 1;
---
- metadata:
- name: COLUMN1
type: integer
- name: COLUMN2
type: string
rows:
- [1, 'B']
...
The result includes:
Metadata: the names and data types of each column
Result rows
For conciseness, metadata is skipped in query results in this tutorial. Only the result rows are shown.
CREATE TABLE
Here is ``CREATE TABLE`` with more details:
There are multiple columns, with different data types.
There is a ``PRIMARY KEY`` (unique and not-null) for two of the columns.
CREATE TABLE table2 (column1 INTEGER,
column2 VARCHAR(100),
column3 SCALAR,
column4 DOUBLE,
PRIMARY KEY (column1, column2));
The result is: ``row_count: 1``.
INSERT
Put four rows in the table:
The INTEGER and DOUBLE columns get numbers
The VARCHAR and SCALAR columns get strings (the SCALAR strings are expressed as hexadecimals)
INSERT INTO table2 VALUES (1, 'AB', X'4142', 5.5);
INSERT INTO table2 VALUES (1, 'CD', X'2020', 1E4);
INSERT INTO table2 VALUES (2, 'AB', X'2020', 12.34567);
INSERT INTO table2 VALUES (-1000, '', X'', 0.0);

Loading…

User avatar None

New source string

testing_project / Documentation: how-to/sql/sql_tutorial — English

tarantool> SELECT * FROM table1 WHERE column1 = 1;
---
- metadata:
- name: COLUMN1
type: integer
- name: COLUMN2
type: string
rows:
- [1, 'B']
...
2 years ago
Browse all string changes

Things to check

Ellipsis

The string uses three dots (...) instead of an ellipsis character (…)

Reset

Glossary

English English
No related strings found in the glossary.

String information

Flags
read-only
String age
2 years ago
Last updated
2 years ago
Source string age
2 years ago
Translation file
string 16