node-sqlite3 事务 TRANSACTION

let sqlite3 = require('sqlite3').verbose();
    let db = new sqlite3.Database('E:/Code/Sqlite/test.db'); db.run("CREATE TABLE lorem (info TEXT)"); db.serialize(function () { db.run('BEGIN'); let stmt = db.prepare("INSERT INTO lorem VALUES (?)"); for (let i = 0; i < 500; i++) { stmt.run("Ipsum " + i); } stmt.finalize(); db.run('COMMIT'); }); db.close();

转载于:https://www.cnblogs.com/liukaigsx/p/6697676.html