How to Execute an SQL Query

Last Updated: October 21, 2021

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 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. Here is how to do a 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.

Steps

1
Fill in the following fields. Host: localhost (by default); User: user_name; Password: user_password. After this, choose a database you want to use.
2
Click on the Query Builder icon and take a look at the left side of your screen. You will see the Database Explorer area.

Advertisement
3
In Database Explorer, click on the plus and choose schema objects you are going to work with. Move them to the query document located in the middle of your screen.
4
If you want, you can select another table and also move it to the query document. The tool will automatically generate joins between objects (if any).
5
Perform any actions with schema objects and press F5.

Community Q&A

Question

How do I create a web application that can manipulate data in a database?

Community Answer

You will need to know PHP to style the page, as well as SQL. w3schools provides a good platform for learning both.