The Node Craftsman Book

A first database application

Once you are up and running, let's start with a first, simple database application. Create a file index.js in the directory where you installed the mysql module, and fill it with the following code:

'use strict';

var mysql = require('mysql');

var connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'root'
});

connection.query(
  'SELECT "foo" AS first_field, "bar" AS second_field',
  function (err, results, fields) {
    console.log(results);
    connection.end();
  }
);

Let's see what exactly happens here. First, we include the external mysql library at var mysql = require('mysql' line. We then create a new object dubbed connection in the var connection = mysql.createConnection({ line.

This object ...