Designing SQL UPDATE Query using dbForge Query Builder for MySQL
This video covers how to create SELECT query, preview updated data, convert SELECT query to UPDATE query, and then run it with MySQL Query Builder Tool by Devart.
ℹ️ Read more about dbForge Query Builder for MySQL:
https://www.devart.com/dbforge/mysql/querybuilder/
💡 Download a 30-days trial version of dbForge Query Builder for MySQL:
https://www.devart.com/dbforge/mysql/querybuilder/download.html
✅ Subscribe to our channel:
https://www.youtube.com/user/DevartSoftware/
#MySQL, #Query, #MySqlUpdateQuery, #QueryBuilder, #dbforge, #Devart
Closed Caption:
In this tutorial, we will show how to:
- create a SELECT query,
- preview updated data,
- convert a SELECT query to an UPDATE query and run it.
Let's select the Example.Customer table and check its content.
You can see that the Address type for all
records equals "Home".
Let's create a query that will change the
"Home" value to "Office"for all rows with
the CustomerID field values between 130 and 730.
Send the table to the Query Builder.
The SELECT query for the table was created.
Now, let's specify a selection condition:
Values of the CustomerID column are between
130 and 730.
You can preview the rows that have to be changed.
You can see a lot of matching records.
Now change the query type to UPDATE, select the AddressType as the column to be updated,
and set its value to "Office".
Execute the query.
Now return to the table and refresh it to
review the updated data.
Click the Filter icon on the AddressType column header and select "Office".
You can see that the required rows were successfully updated, while the rest of the rows remain unchanged.
You can download dbForge Query Builder for MySQL at the devart.com website.
Video Length: 01:37
Uploaded By: Devart
Published: 6/29/2020
View Count: 738