Examples MySQL Connection

The MySQL driver connects to a local or remote MySQL server over an IP connection. The MySQL driver supports transactions.

Connection URL

mysql://[[username]:[password]@]host[:port]/database

Usage

const Connection = require('database-js2').Connection;

var connection = new Connection('mysql://user:password@localhost/data');

Select Some Data

var Connection = require('database-js2').Connection;

(async function() {
    let connection, statement, rows;
    try {
        connection = new Connection('mysql://my_secret_username:my_secret_password@localhost:3306/my_top_secret_database');
        statement = await connection.prepareStatement("SELECT * FROM tablea WHERE user_name = ?");
        rows = await statement.query('not_so_secret_user');
        console.log(rows);
    } catch (error) {
        console.log(error);
    } finally {
        if (connection) {
          await connection.close();
        }
    }
})();