setup session parameter while making a connection

[ghost]

Hi, Is there any way to setup session parameter in underlying library. like

set session autocommit=ON;

Thanks !

[CodeFoodPixels]

From looking at https://github.com/mysqljs/mysql#pool-events, you can listen for the connection event. You should be able to use it like this:

pool = mysql.createPool({
  host: 'localhost',
  user: 'sauron',
  password: 'theonetruering',
  database: 'mordor',
  connectionLimit: 10
});

pool.on('connection', function (connection) {
  connection.query('set session autocommit=ON')
});

[ghost]

Thank You !