Node.js MySQL Update Records
The UPDATE command is used to update records in the table.
Example
Update city in "employees" table where id is 1.
Create a js file named "update" in DBexample folder and put the following data into it:
- var mysql = require('mysql');
- var con = mysql.createConnection({
- host: "localhost",
- user: "root",
- password: "12345",
- database: "javatpoint"
- });
- con.connect(function(err) {
- if (err) throw err;
- var sql = "UPDATE employees SET city = 'Delhi' WHERE city = 'Allahabad'";
- con.query(sql, function (err, result) {
- if (err) throw err;
- console.log(result.affectedRows + " record(s) updated");
- });
- });
Now open command terminal and run the following command:
- Node update.js
It will change the city of the id 1 is to Delhi which is prior Allahabad.
You can check the updated record in the new table:
In the old table city of "Ajeet Kumar" is Allahabad.
