Using Express.js and node.js to get a select from MySQL

Question

I'm trying to print the query but it doesn't show nothing. I cant't to figure out why the code doesn't work. The connection works but the query doesn't.

var express = require('express');
var path = require('path');
var mysql = require('mysql');
var app = express();

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

connection.query('USE database');

app.set('port', 3001);

app.get('/',function(req, res) {
  connection.query('SELECT * from test', function(err, rows, fields) {
    if (err) throw err;
    console.log('this is the result = ', rows[0].field);
  });
});

Shimon Brandsdorfer · Accepted Answer · 2017-07-18 00:41:42Z

1

You have to connect to the database, by writing:

connection.connect();

answered Jul 18, 2017 at 0:41

Shimon Brandsdorfer

1,7239 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

Using Express.js and node.js to get a select from MySQL

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related