You have two options if you want to build a query.The first way is using a console.You have to remember all the commands and keys if you build your queries in the console.This is not an easy way to execute a query.Another way to use a graphical interface is with a database.It can fulfill many requirements.An example of how to do a step-by-step query execution process is provided.You can only execute your query if you keep an account information in your memory.You will be able to create queries in a visual query editor with the GUI tool, which will save you a lot of time.
Step 1: You can fill in the following fields.
Password: user_password; Host: localhost (by default).Pick the database you want to use.
Step 2: Take a look at the left side of the screen if you click on the Query Builder icon.
You can see the area.
Step 3: Click on the plus and choose the objects you want to work with.
They should be located in the middle of your screen.
Step 4: If you want, you can pick another table and move it to the query document.
If any, the tool will create joins between objects.
Step 5: Press F5 if you want to perform any actions.