CODE EXAMPLE FOR JAVASCRIPT

nodejs mysql getting the id of an inserted row

//If you are inserting a row into a table with an auto increment primary key, you can retrieve the insert id like this:
connection.query('INSERT INTO posts SET ?', {title: 'test'}, function (error, results, fields) {
  if (error) throw error;
  console.log(results.insertId);
});