Untitled

var express = require('express');
var router = express.Router();
var mysql = require('mysql');


/* GET home page */
router.get('/', function(req, res, next) {
  var connection = mysql.createConnection({
    host : '',
    user : '',
    password : '',
    database : ''
  });

  connection.connect();

  connection.query('SELECT hashtag from recipients', function(err, rows, fields) {
    if (!err) {
      console.log(rows);
      //send rows to template engine to render HTML.
      res.render('mysql', {
        rows: rows,
        title:''
      });
    } else {
      console.log('Error while performing Query.');
    }
  });
  connection.end();
});

// Important
module.exports = router;

<html>

<head>
  <title> <%= title %></title>
</head>

<body>
  <table>
    <tr>some heading</tr>
    <% for(var i=0; i< rows.length; i++) { %>
      <tr>
        <td>
          <%= rows[i] %>
        </td>
      </tr>
      <% } %>

  </table>
</body>

</html>