Changes

Jump to: navigation, search

The MySQL Query Browser

1,425 bytes added, 19:06, 1 October 2007
A Tour of MySQL Browser
[[image:mysql_query_browser_main.jpg]]
 
At the top of the window is a large text input field. 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 section at the bottom of the window appears to display any errors encountered as a result of a SQL statement.
 
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. 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 tables from the database.
 
The bottom right side of the main window provides a lost of help topics. Double clicking on a list item will display help text in the result area of the screen.
 
== Executing SQL Statements ==

Navigation menu