Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
MySQL database bindings for Node.js

This branch is 8 commits behind imkira:master

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
lib
src
.gitignore
.gitmodules
.npmignore
CHANGELOG
README.md
db-mysql.js
package.json
tests-settings.json
tests.js
wscript

README.md

db-mysql: MySQL database bindings for Node.js

For detailed information about this and other Node.js database bindings visit the Node.js db-mysql homepage.

INSTALL

Before proceeding with installation, you need to have the libmysql development libraries and include files. Access to the mysql_config binary is mandatory, and its path has to be specified prior to installation (if its not within the system's path). For example, if the path to your mysql_config is /usr/local/bin/mysql_config make sure to do the following (Ubuntu users need to install the libmysqlclient-dev package):

$ export MYSQL_CONFIG=/usr/local/bin/mysql_config

Once you are sure that either mysql_config is part of the path or that you specified the MYSQL_CONFIG environment var, install with npm:

$ npm install db-mysql

QUICK START

var mysql = require('db-mysql');
new mysql.Database({
    hostname: 'localhost',
    user: 'root',
    password: 'password',
    database: 'node'
}).connect(function(error) {
    if (error) {
        return console.log("CONNECTION ERROR: " + error);
    }

    this.query().select('*').from('users').execute(function(error, rows) {
        if (error) {
            return console.log('ERROR: ' + error);
        }
        console.log(rows.length + ' ROWS');
    });
});

LICENSE

This module is released under the MIT License.

Something went wrong with that request. Please try again.