wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time.
This article has been viewed 41,359 times.
Learn more...
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
-
1Fill in the following fields. Host: localhost (by default); User: user_name; Password: user_password. After this, choose a database you want to use.
-
2Click on the Query Builder icon and take a look at the left side of your screen. You will see the Database Explorer area.Advertisement
-
3In 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.
-
4If 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).
-
5Perform any actions with schema objects and press F5.
Community Q&A
-
QuestionHow do I create a web application that can manipulate data in a database?
Community AnswerYou will need to know PHP to style the page, as well as SQL. w3schools provides a good platform for learning both.
