How can I query MySQL with node.js?

Question

I am going to make a client-server application using Node.js, and I want to use a MySQL database for storing some of the data. I need to know how to query a database with server-side JavaScript.

Quentin · Accepted Answer · 2012-03-29 12:37:41Z

5

Search the module library for mysql and you will get many modules that will let you do that including mysql, db-mysql, and easy-mysql.

edited Mar 29, 2012 at 12:37

answered Mar 29, 2012 at 12:32

Quentin

948k136 gold badges1.3k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Brad Harris · Accepted Answer · 2012-03-30 05:54:58Z

4

npm install node-mysql

var mysql = require('mysql'),
    client = mysql.createClient({
        user: 'root',
        password: 'root',
    });

mysql.query('SELECT * FROM my_table', function(err, results, fields) {
    //have fun         
    client.end();
});

There are other libraries as well that all have slightly different APIs.

answered Mar 30, 2012 at 5:54

Brad Harris

1,5209 silver badges12 bronze badges

Collectives™ on Stack Overflow

How can I query MySQL with node.js?

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related