Header Banner
WonderHowTo Logo
WonderHowTo
PHP
wonderhowto.mark.png
Gadget Hacks Next Reality Food Hacks Null Byte The Secret Yumiverse Invisiverse Macgyverisms Mind Hacks Mad Science Lock Picking Driverless
Home
PHP

How to Execute a Basic SQL Query Using dbForge Studio GUI for MySQL

If you need to build a SQL query, you can choose one of two alternatives. The first and a rather old way is using a console. But if you build your queries in MySQL console, you have to remember all the commands and keys. This is not a convenient way, because query execution is a time-consuming process. Another way is to use some graphical interfaces for MySQL. It can fulfill many developers' requirements, including query execution. 

I'd like to show you step-by-step query execution process using dbForge Studio for MySQL as an example. With this MySQL GUI tool, you can execute your query only keeping an account information (login, password) in your memory. The GUI tool will save you a lot of time and will help to prevent errors, as you will be able to create queries in a visual query editor.

Run dbForge Studio for MySQL. Then choose an existing connection or create a new one.

Fill in the following fields: 

Host: localhost (by default); User: user_name; Password: user_password.

After this, choose a database you want to use.

Click on the Query Builder icon and take a look at the left side of your screen. You will see the Database Explorer area.

In Database Explorer, click on the plus and choose the schema objects you are going to work with. Move them to the query document located in the middle of your screen.

If you want, you can select another table and also move it to the query document.

The tool will automatically generate joins beetwen objects (if any).

Perform any actions with schema objects and press F5.

The tool will execute the query, and you will find the results of query execution on the text or data tabs located in the bottom of the query document.

Apple's iOS 26 and iPadOS 26 updates are packed with new features, and you can try them before almost everyone else. First, check Gadget Hacks' list of supported iPhone and iPad models, then follow the step-by-step guide to install the iOS/iPadOS 26 beta — no paid developer account required.

Related Articles

Comments

No Comments Exist

Be the first, drop a comment!