117

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:

Now open command terminal and run the following command:

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.