Adding a row with multiple columns using Node.js & sqllite3

Question

Using Node.JS with the SQLlite3 module I created a table: 'users' in my database with 2 columns: 'name' and 'surname'.

// Importing database
var fs = require('fs');
var file = 'test.db';
var exists = fs.existsSync(file);
var sqlite3 = require("sqlite3").verbose();
let db = new sqlite3.Database(file)

//inserting first user
db.run('INSERT INTO users VALUES(?, ?)', ['"John", "Doe"'])
db.close();

Instead of adding the value 'John' to 'name' and 'Doe' to surname, it adds the value ' "John", "Doe" ' to name and null to surname.

TAS · Accepted Answer · 2018-03-30 16:12:22Z

4

Parameter of db.run should have been passed as an array when using multiple placeholders instead of a string. Solution:

db.run('INSERT INTO users VALUES(?, ?)', ['John', 'Doe'])
db.close();

answered Mar 30, 2018 at 16:12

TAS

15612 bronze badges

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

1 Comment

kaushalop Over a year ago

Thank you for stating the most simple and direct answer which is not answered in proper tutorials also!

Collectives™ on Stack Overflow

Adding a row with multiple columns using Node.js & sqllite3

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related