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.
Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.
Other worthwhile deals to check out:
- 97% off The Ultimate 2021 White Hat Hacker Certification Bundle
- 98% off The 2021 Accounting Mastery Bootcamp Bundle
- 99% off The 2021 All-in-One Data Scientist Mega Bundle
- 59% off XSplit VCam: Lifetime Subscription (Windows)
- 98% off The 2021 Premium Learn To Code Certification Bundle
- 62% off MindMaster Mind Mapping Software: Perpetual License
- 41% off NetSpot Home Wi-Fi Analyzer: Lifetime Upgrades