MySQL Query Browser Overview
Posted by on 02 July 2012 10:56 AM
|
|
MySQL Query Browser is an alternative to phpMyAdmin when it comes to managing your MySQL databases. You can use it to create, drop, and edit tables and perform queries. Setting up MySQL Query Browser to work with your account is relatively simple. PreparationBefore you even download Query Browser, you must first prepare your account. You will need an existing database and a user who has permissions on that database.
Download, Installation, and SetupMySQL offers Query Browser as part of their GUI Tools bundle.
You can easily change between databases once you've connected. If you correctly added your IP address to the list of allowed hosts and you entered the right information to connect, then Query Browser's interface will open up and you can start managing your database! Infinity and BeyondThe main Query Browser window has three important areas. Along the top is the text area where you can build and execute SQL queries. Below this is the results area. You can use manage multiple result sets at once using tabs and even split a tab so you can compare two sets. To the right of the results area is a list of databases and their tables. These allow you to quickly switch between databases and view or edit tables. Although you can do everything manually via SQL query, the Query Browser has decent GUI tools to create and edit table structures, which can often save time and stress over a misplaced quotation mark. It also comes with built-in documentation, allowing you to recall query syntax at the click of a button. | |
|