Navigate back to the homepage

Node sequelize update query example

Infinitbility
Node, Sequelize
July 1st, 2021 · 1 min read

Hello Friends,

Welcome To Infinitbility!

To update data in the database, sequelize provide update() method it will update your data on the database based on your condition. using sequelize update method we are able to write SQL update query in a function and JSON parameters.

This article based on sequelize update query, here you will get update query examples to do on your project.

If you are looking for sequelize basics query example for crud check below article it’s based on sequelize create, select, delete, and update, and join examples

https://infinitbility.com/node.js-sequelize-query-examples

Let’s start today’s article Node sequelize update query example

Today we will learn how many types update query have in Node sequelize.

update query with condition

When you want to update some field based on some condition then you can use simply update query provide by sequelize example like below.

1// Change everyone without a last name to "Doe"
2await User.update({ lastName: "Doe" }, {
3 where: {
4 lastName: null
5 }
6});

update query with select

sequelize provide option update query after selection done, like first select some data using findOne() after update record using save() understand with example.

1const user = User.findOne({
2 attributes: ['first_name', 'last_name'],
3 where: {
4 id: 2
5 }
6});
7
8user.first_name = "infinitbility";
9user.save();

Thanks for reading…

Follow me on Twitter

Join our email list and get notified about new content

No worries, I respect your privacy and I will never abuse your email.

Every week, on Tuesday, you will receive a list of free tutorials I made during the week (I write one every day) and news on other training products I create.

Looking For React Native Tutorial?

we are trying to create the best Tutorial for react native developers.

When you want a daily updates about React Native Tutorial or infinitbility update subscribe to our newsletter.

Read React Native Tutorial

Request New Tutorial or Article on mail [email protected]

Guide book

Guidebook: The Javascript Monorepo Photoshop Guide

Tutorials

Categories

More articles from Infinitbility

Node sequelize where or query example

How to use where or in node sequelize

June 30th, 2021 · 1 min read

How to detect video finished in video react

Video react onEnded example

June 29th, 2021 · 1 min read
© 2020–2022 Infinitbility
About
Link to $https://medium.com/infinitbilityLink to $https://www.facebook.com/InfinitbilityLink to $https://github.com/infinitbilityLink to $https://twitter.com/infinitbilityLink to $https://www.buymeacoffee.com/infinitbilityLink to $mailto:[email protected]