Editing SQL Data using dbForge Query Builder for MySQL
Learn how to edit SQL data with the foreign key functionality, Insert, Update, Delete, and Export data in 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, #QueryBuilder, #QueryTool, #dbforge, #Devart
Closed Caption:
Welcome to dbForge Query Builder for MySQL
Tutorials.
In this tutorial, we are going to learn how
to:
edit data with the foreign key look up functionality, insert, update, delete and export data.
Retrieve data from the table.
Append a new row to it.
We will use the Foreign Key Lookup feature to save data consistency and speed up the input.
With the Date editor, you can quickly set
a new date or modify the current one.
After editing, you can apply changes by clicking End Edit or roll back modifications by clicking
Cancel Edit.
Let's select End Edit.
As you can see, the data was added successfully.
Instead, it is more reliable to use the Cached Updates Mode.
Let's enable this mode and update several
columns.
Updates are stored locally on the client side until you click the Apply Changes button.
If you close the document in the cached updates mode, you will cancel all changes made since
the last Apply command.
If you don’t need for the changes to be
applied, click the Cancel Changes button.
As you can see, the changes have been canceled.
Let's delete a few records and apply this
command.
To simplify the data recovery process, we
can present the table data either fully or
partially as a script with insert commands.
You can see the script in the SQL Document.
It is also possible to export data to many
popular formats.
As an example, let's export data to the MS
Excel format.
Data Export Wizard includes a wide range of options to customize your export operation.
Data Export was performed successfully.
Let's use the StoreWithDemographics view.
We can modify field values of the tables it
contains.
You have been watching the dbForge Query Builder for MySQL Tutorial.
You can download a 30-day trial edition of
dbForge Query Builder for MySQL at Devart.com
Video Length: 02:12
Uploaded By: Devart
Published: 6/25/2020
View Count: 972