Zen

Source string Source string

123/10000 · 123
English Actions
Heading
Summary
:ref:`Getting Started <sql_getting_started>`
Typing SQL statements on a console
:ref:`Supported Syntax <sql_supported_syntax>`
For example what characters are allowed
:ref:`Concepts <sql_concepts>`
tokens, literals, identifiers, operands, operators, expressions, statements
:ref:`Data type conversion <sql_data_type_conversion>`
Casting, implicit or explicit
Getting Started
The explanations for installing and starting the Tarantool server are in earlier chapters of the Tarantool manual.
To get started specifically with the SQL features, using Tarantool as a client, execute these requests:
box.cfg{}
box.execute([[VALUES ('hello');]])
The bottom of the screen should now look like this:
tarantool> box.execute([[VALUES ('hello');]])
---
- metadata:
- name: COLUMN_1
type: string
rows:
- ['hello']
...
That's an SQL statement done with Tarantool.
Now you are ready to execute any SQL statements via the connection. For example
box.execute([[CREATE TABLE things (id INTEGER PRIMARY key,
remark STRING);]])
box.execute([[INSERT INTO things VALUES (55, 'Hello SQL world!');]])
box.execute([[SELECT * FROM things WHERE id > 0;]])
And you will see the results of the SQL query.
For the rest of this chapter, the :ref:`box.execute([[...]]) <box-sql>` enclosure will not be shown. Examples will simply say what a piece of syntax looks like, such as ``SELECT 'hello';`` |br| and users should know that must be entered as |br| ``box.execute([[SELECT 'hello';]])`` |br| It is also legal to enclose SQL statements inside single or double quote marks instead of [[ ... ]].
Supported Syntax
Keywords, for example CREATE or INSERT or VALUES, may be entered in either upper case or lower case.
Literal values, for example ``55`` or ``'Hello SQL world!'``, should be entered without single quote marks if they are numeric, and should be entered with single quote marks if they are strings.
Object names, for example table1 or column1, should usually be entered without double quote marks and are subject to some restrictions. They may be enclosed in double quote marks and in that case they are subject to fewer restrictions.
Almost all keywords are :ref:`reserved <sql_reserved_words>`, which means that they cannot be used as object names unless they are enclosed in double quote marks.
Comments may be between ``/*`` and ``*/`` (bracketed) or between ``--`` and the end of a line (simple).
INSERT /* This is a bracketed comment */ INTO t VALUES (5);
INSERT INTO t VALUES (5); -- this is a simple comment
Expressions, for example ``a + b`` or ``a > b AND NOT a <= b``, may have arithmetic operators ``+ - / *``, may have comparison operators ``= > < <= >= LIKE``, and may be combined with ``AND OR NOT``, with optional parentheses.
Concepts
In the :ref:`SQL beginners' guide <sql_beginners_guide>` there was discussion of: |br| What are: relational databases, tables, views, rows, and columns? |br| What are: transactions, write-ahead logs, commits and rollbacks? |br| What are: security considerations? |br| How to: add, delete, or update rows in tables? |br| How to: work inside transactions with commits and/or rollbacks? |br| How to: select, join, filter, group, and sort rows?

Loading…

User avatar None

New source string

testing_project / Documentation: reference/reference_sql/sql_user_guide — English

tarantool> box.execute([[VALUES ('hello');]])
---
- metadata:
- name: COLUMN_1
type: string
rows:
- ['hello']
...
a year 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
a year ago
Last updated
a year ago
Source string age
a year ago
Translation file
string 18