Modifying Data
The following code examples show how to use data modification statements.
Procedure for Updates
You can use separate statements to execute data modification statements. Once you create the statement, you can call its executeNonQueryMethod and retrieve the number of affected rows.
INSERT
To insert updates:
db.open("...", (err) => { db.prepare("INSERT INTO Posts(FromName) VALUES ('User 2')", (err, stmt) => { stmt.executeNonQuery((err, affected) => { console.log("Affected: " + affected); }); }); });
UPDATE
To retrieve updates:
db.open("...", (err) => { db.prepare("UPDATE Posts SET FromName = 'User 2' WHERE ID = '11111'", (err, stmt) => { stmt.executeNonQuery((err, affected) => { console.log("Affected: " + affected); }); }); });
DELETE
To delete updates:
db.open("...", (err) => { db.prepare("DELETE FROM Posts WHERE Id = '11111_22222'", (err, stmt) => { stmt.executeNonQuery((err, affected) => { console.log("Affected: " + affected); }); }); });