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.
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 area.
In Database Explorer, click on the plus and choose schema objects you are going to work with.
Move them to the 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 between objects (if any).