Loading

Bulk insert into Sqlite

Sasi Rekha

How to insert bulk records into sqlite without using any loops?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sasi Rekha7y ago
knex.batchInsert('ArrivalInfo', result, 5).then(function (rows) {
console.log("rows "+rows.length);
//callback(null, 'ok')
}).catch(function(error) {
console.log(error);
//callback(error)
})

need to install knex first
ArrivalInfo is the table name and 5 is the noofrecords at a time we are going to insert
Jaish Mathews8y ago
Depends on what you are inserting? InsertAll() and UpdateAll() would do bulk insert. Ref. here https://stackoverflow.com/questions/36778304/how-to-bulk-insert-into-sqlite-database