{"id":1258,"date":"2017-06-26T11:40:40","date_gmt":"2017-06-26T04:40:40","guid":{"rendered":"http:\/\/www.sqlitetutorial.net\/?page_id=1258"},"modified":"2024-10-27T21:24:00","modified_gmt":"2024-10-27T14:24:00","slug":"updating-data-sqlite-database-node-js-application","status":"publish","type":"page","link":"https:\/\/www.sqlitetutorial.net\/sqlite-nodejs\/update\/","title":{"rendered":"SQLite Node.js: Updating Data"},"content":{"rendered":"\n

Summary<\/strong>: In this tutorial, you will learn how to update data in a table of an SQLite database from a Node.js application.<\/p>\n\n\n\n

This tutorial begins where the “Inserting Data into a Table in Node.js”<\/a> tutorial left off.<\/p>\n\n\n\n

Steps for updating data in a table in Node.js<\/h2>\n\n\n\n

To update data in an SQLite table from a Node.js app, you follow these steps:<\/p>\n\n\n\n

First, import sqlite3<\/code> from the sqlite3<\/code> module:<\/p>\n\n\n

import<\/span> sqlite3 from<\/span> \"sqlite3\"<\/span>;<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
const<\/span> db = new<\/span> sqlite3.Database(filename);<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
db.run(sql, params, callback);<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
Finally, close the database connection:<\/p>\n\n\n
db.close()<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
If you have not followed the previous tutorial, you can download the my.db<\/code> database here and copy it to the project directory.<\/p>\n\n\n\n
Updating data in a table<\/h2>\n\n\n\n
Step 1. Change the update.js<\/code> file to update the data in the products<\/code> table:<\/p>\n\n\n
import sqlite3 from \"sqlite3\";\nimport { execute<\/span> } from<\/span> \".\/sql.js\"<\/span>;\n\nconst main = async () => {\n  const db = new sqlite3.Database(\"my.db\");\n  const sql = `UPDATE<\/span> products SET<\/span> price = ? WHERE<\/span> id<\/span> = ?`;\n  try {\n    await execute(db, sql, [1000.99, 1]);\n  } catch (err) {\n    console.log(err);\n  } finally {\n    db.close();\n  }\n};\n\nmain();<\/span><\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Step 2. Open the terminal and execute the following command to run the Node.js app:<\/p>\n\n\n
node<\/span> update<\/span>.js<\/span><\/code><\/span>Code language:<\/span> CSS<\/span> (<\/span>css<\/span>)<\/span><\/small><\/pre>\n\n\n
Step 3. Verify the update:<\/p>\n\n\n\n
First, open a new terminal and use the sqlite3<\/code> tool to connect to the my.db<\/code> database:<\/p>\n\n\n
sqlite3 my.db<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
Second, format the output:<\/p>\n\n\n
.header<\/span> on<\/span>\n.mode<\/span> column<\/span>\n.nullvalue<\/span> null<\/span><\/code><\/span>Code language:<\/span> CSS<\/span> (<\/span>css<\/span>)<\/span><\/small><\/pre>\n\n\n
Second, query data from the products<\/code> table:<\/p>\n\n\n
SELECT<\/span> * FROM<\/span> products;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
id  name    price\n--  ------  -------\n1<\/span>   iPhone  1000.99<\/span><\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
The output indicates that the price has been updated to 1000.99<\/code> successfully.<\/p>\n\n\n\n
Summary<\/h2>\n\n\n\n
    \n
  • Use the run()<\/code> method of the Database<\/code> object to execute an UPDATE<\/code> statement to update data in a table.<\/li>\n<\/ul>\n
    \n\t
    \n\t\t
    Was this tutorial helpful ?<\/div>\n\t\t
    \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
    \n\t\t
    \n\t\t\t
    <\/div>\n\t\t\t\n\t\t\t
Third, execute an UPDATE<\/a> statement statement using the run()<\/code> method of the Database<\/code> object:<\/p>\n\n\n
Second, open a database connection to an SQLite database<\/a>:<\/p>\n\n\n