Zen

Source string Source string

319/10000 · 319
English Actions
Begin by making a ``require`` request for the mysql driver. We will assume that the name is ``mysql`` in further examples.
mysql = require('mysql')
Now, say:
*connection_name* = mysql.connect(*connection options*)
The connection-options parameter is a table. Possible options are:
:samp:`host = {host-name}` - string, default value = 'localhost'
:samp:`port = {port-number}` - number, default value = 3306
:samp:`user = {user-name}` - string, default value is operating-system user name
:samp:`password = {password}` - string, default value is blank
:samp:`db = {database-name}` - string, default value is blank
:samp:`raise = {true|false}` - boolean, default value is false
The option names, except for `raise`, are similar to the names that MySQL's mysql client uses, for details see the MySQL manual at `dev.mysql.com/doc/refman/5.6/en/connecting.html <https://dev.mysql.com/doc/refman/5.6/en/connecting.html>`_. The `raise` option should be set to :codenormal:`true` if errors should be raised when encountered. To connect with a Unix socket rather than with TCP, specify ``host = 'unix/'`` and :samp:`port = {socket-name}`.
Example, using a table literal enclosed in {braces}:
conn = mysql.connect({
host = '127.0.0.1',
port = 3306,
user = 'p',
password = 'p',
db = 'test',
raise = true
})
-- OR
conn = mysql.connect({
host = 'unix/',
port = '/var/run/mysqld/mysqld.sock'
})
Example, creating a function which sets each option in a separate line:
tarantool> -- Connection function. Usage: conn = mysql_connect()
tarantool> function mysql_connection()
> local p = {}
> p.host = 'widgets.com'
> p.db = 'test'
> conn = mysql.connect(p)
> return conn
> end
---
...
tarantool> conn = mysql_connect()
---
...
We will assume that the name is 'conn' in further examples.
How to ping
To ensure that a connection is working, the request is:
*connection-name*:ping()
**Example:**
tarantool> conn:ping()
---
- true
...
Executing a statement
For all MySQL statements, the request is:
*connection-name*:execute(*sql-statement* [, *parameters*])
where ``sql-statement`` is a string, and the optional ``parameters`` are extra values that can be plugged in to replace any question marks ("?"s) in the SQL statement.
tarantool> conn:execute('select table_name from information_schema.tables')
---
- - table_name: ALL_PLUGINS
- table_name: APPLICABLE_ROLES
- table_name: CHARACTER_SETS
<...>
- 78
...
Closing connection
To end a session that began with ``mysql.connect``, the request is:
*connection-name*:close()
tarantool> conn:close()
---
...

Loading…

User avatar None

New source string

testing_project / Documentation: reference/reference_rock/dbms — English

tarantool> -- Connection function. Usage: conn = mysql_connect()
tarantool> function mysql_connection()
> local p = {}
> p.host = 'widgets.com'
> p.db = 'test'
> conn = mysql.connect(p)
> return conn
> end
---
...
tarantool> conn = mysql_connect()
---
...
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 39