CODEWITHSUNDEEP
javascriptsqlnode.js
Willie
Willie

Reputation: 123

node js sql output

I am trying to come up with the node.js code to get the output of this query:

const viewAllEmployees = () => {
let sql = 'SELECT e.id, e.first_name, e.Last_name, r.title, d.name as "Department", salary, CONCAT (m.first_name," ", m.last_name) AS "Manager" 
FROM employee e '  + connection.escape('INNER JOIN employee m 
ON e.manager_id = m.id 
LEFT JOIN role r 
ON e.role_id = r.id 
LEFT JOIN department d 
on r.department_id = d.id');
    connection.query(sql, (err, res) => {
    if (err) throw err;
    console.table(res);
    // console.log(res);
    //connection.end();
  });

The problem is that when I use it without the connection.escape(), I get the output, but with single quotes like this:

enter image description here

How can I (1) get rid of the (index) column, and (2) get rid of the single quotes? Getting rid of the single quotes is really the priority.

Thanks!

Upvotes: 0

Views: 367

Answers (1)

Eugene Botyanovsky
Eugene Botyanovsky

Reputation: 871

Index column and quotes are added by console.table function itself.

You can check it running console.table with any static data like here: https://developer.mozilla.org/en-US/docs/Web/API/Console/table#collections_of_primitive_types

To print it in a way you want it, implement printing function on your own.

Upvotes: 1

Related Questions