Getting last id when inserting several rows

Question

I'm using nodeJS and mysql to insert a few rows in my database. Here is my code:

 connection.query('INSERT INTO trainings (file_id, selection_start, selection_end, label_id) VALUES ?', [toInsert], function(err, results){ ... }

As you can see I'm inserting several rows at a time. How can I get all the inserted id if my table is in autoIncrement?

results.insertId only returns one ID (and not all)

Any idea on how I could fix that?

if answer correct you should up vote it

Gaurav Gupta
– Gaurav Gupta

2017-11-18 21:31:16 +00:00
Commented Nov 18, 2017 at 21:31 — Gaurav Gupta
– Gaurav Gupta, Commented Nov 18, 2017 at 21:31

Ashish Dadhich · Accepted Answer · 2017-05-05 18:44:22Z

1

put results.insertId values into an array

var lastIds = []; /* you insert data method callback with model */ model.insertDataRow(request.body,function(err,results){ lastIds.push(results.insertId) })

answered May 5, 2017 at 18:44

Ashish Dadhich

964 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Vico Over a year ago

I might be wrong but it's not doing all the inserts at the same time (how can I know all the rows have been inserted?). My callback function is only called once (I assume when all the rows have been inserted)

Ashish Dadhich Over a year ago

like: connection.query('INSERT INTO posts SET ?', {title: 'test'}, function(err, result) { if (err) throw err; console.log(result.insertId); }); put result.insetId into array and return to fetch that... hope it might be work. reference: github.com/felixge/node-mysql/…

Collectives™ on Stack Overflow

Getting last id when inserting several rows

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related