Designing SQL UPDATE Query using dbForge Query Builder for MySQL

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

Related Software Products
dbForge Query Builder for MySQL
dbForge Query Builder for MySQL

Published By:
Devart

Description:
dbForge Query Builder for MySQL: Draw Your Queries Instead of Typing Them dbForge Query Builder for MySQL is Devart's Windows tool for building MySQL and MariaDB queries on a visual diagram: you drag tables onto a canvas, it draws the joins, and it writes the SELECT, INSERT, UPDATE or DELETE statement for you. It costs $74.95 a year or $149.95 for a perpetual license, and it suits analysts, report writers and developers who would rather see a...


Related Videos
Designing SQL SELECT Query using dbForge Query Builder for MySQL
Designing SQL SELECT Query using dbForge Query Builder for MySQL

Video Length: 03:17
Uploaded By: Devart (6/26/2020)
View Count: 3,088

MySQL Query Optimization with dbForge Visual Query Builder
MySQL Query Optimization with dbForge Visual Query Builder

Video Length: 02:25
Uploaded By: Devart (7/23/2021)
View Count: 1,645

Editing SQL Data using dbForge Query Builder for MySQL
Editing SQL Data using dbForge Query Builder for MySQL

Video Length: 02:12
Uploaded By: Devart (6/25/2020)
View Count: 972

Designing SQL INSERT Query using dbForge Query Builder for MySQL
Designing SQL INSERT Query using dbForge Query Builder for MySQL

Video Length: 02:24
Uploaded By: Devart (9/4/2020)
View Count: 604

Copyright © 2026, Ivertech. All rights reserved.