Inherited from v1.0.0

mysql module

MySQL / MariaDB client backed by libmariadb. Connect with a map of options or a mysql:// URL.

import "mysql" as mysql;

var db = mysql.connect({
    host: "localhost", port: 3306, user: "alice",
    password: "secret", database: "myapp"
});

db.exec("INSERT INTO users (name) VALUES (?)", ["Alice"]);
var rows = db.query("SELECT * FROM users WHERE id = ?", [1]);
print(rows[0].name);

db.close();

Module API

FunctionDescription
mysql.connect(opts) → dbopts map: {host, port, user, password, database, ssl?, connect_timeout?}.
mysql.parse_url(url) → optsParse mysql://user:pass@host:port/db into an opts map.
mysql.version() → stringlibmariadb client version.
mysql.transaction(db, fn)Run fn(db) inside BEGIN/COMMIT.
mysql.migrate(db, statements)Idempotent DDL list.
mysql.insert(db, table, row) → idInsert + last_insert_id().

db handle

Mirrors sqlite — db.exec, db.query, db.query_one, db.last_insert_id, db.changes, db.close. Parameter placeholder: ?.

See also