karmadude/node-mysql2json.js

The mysql library has changed a bit.

var mysql = require('mysql');

// http://nodejs.org/docs/v0.6.5/api/fs.html#fs.writeFile
var fs = require('fs');

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

connection.connect();

connection.query('select * from db.table;', function(err, results, fields) {
    if(err) throw err;

    fs.writeFile('table.json', JSON.stringify(results), function (err) {
      if (err) throw err;
      console.log('Saved!');
    });

    connection.end();
});

Please how to log the sql query with parameter $1 $2 .... like this :

client.query(
"INSERT into mytable (id,title,name) VALUES(nextval('id_seq'),$1, $2) RETURNING id",
[req.title, req.name],

function (err, result) {
    if (err) {
        console.log(err);
    } else {
        console.log('row inserted in annales with id: ' + result.rows[0].id);
    }
    writeData('/api/createannales',  ??  ??  ? );
    client.end();
    return res.json(result.rows[0].id);
  });

How can I export resultset?

var con = mysql.createConnection({
host: "localhost",
user: "root",
password: "password",
database: "staging"
});

con.connect(function(err) {
  if (err) throw err;
  console.log("Connected!");
  var sql = "SELECT * FROM products";
  con.query(sql, function (err, result) {
    if (err) throw err;
    res.end(JSON.stringify(result));
  });
});