Changes

The MySQL Query Browser

6 bytes added, 19:50, 29 October 2007
no edit summary
<hr>
 The MySQL Query Browser is a graphical tool designed to provide a user friendly environment in which to write construct and execute SQL statements.
== Getting and Installing MySQL Query Browser ==
[[image:mysql_query_browser_main.jpg]]
At the top of the window is a large text input field. this This is where SQL statements are typed by the user. Statements can be entered on multiple lines and are not executed until the execute button is pressed (the round green button with the white lightning bolt). An executing statement can be stopped by pressing the red stop button. The ''Back'' and ''Next'' buttons provide a way to page through the history of executed commands.
The large gray area in the center of the screen displays the results of the executed statements. An addition additional section at the bottom of the window appears to display any errors encountered as a result of a SQL statement. Additional '"Resultset'' pages may be added from the File->New Query Tab menu option.
In the top right hand side of the window is a list of databases available on the server to which the tool is currently connected. Clicking the arrow next to any database will display the tables contained therein. Clicking on the arrow next to a table sill. will similarly list the columns in that table. Right clicking with the mouse in this area pops up a menu providing options to create new tables, views and databases. This menu also provides an option to select a different schema to the one chosen at the login screen and provides the option to drop the currently highlight table or database.
The bottom right side of the main window provides a list of help topics. Double clicking on a list item will display help text in the result area of the screen. To return to the results page, either close the ''SQL Help'' tab, or click on the ''Resultset'' tab.