1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
USER GUIDE - Version 1.8
------------------------
When the gui comes up, any databases will be listed in the Databases
browser. All buttons will be greyed out until a database is selected.
You MUST use the mysqladmin program to create databases, so please
see the MySQL documentation. If you have MySQL installed correctly,
you should see the mysql database listed.
Once a database is selected, the database's tables will be listed in
the Tables browser. At this point the "Batch SQL" and "Admin Tables"
buttons will be available.
The Batch SQL dialog allows you to load a batch file for selective
processing. The Batch SQL browser will be loaded with the file.
To submit the query or command, highlight the lines and press the
"Submit" pushbutton. The idea is that you can create a file with
queries, etc. that you routinely run one after another, or to
initialize a database. If the batch query has any output, it will
be displayed in the Results dialog.
The Admin. Tables dialog allows you to create, drop or alter tables.
The dialog contains a command list and data types list. You can either
enter all of your SQL statements in the freeform window, or use the
command and data types lists to speed your input. You can also
save your query via the "Save" button and use it again via the
"Load" button.
By selecting a table from the Tables browser, you can see the fields
in a table. The "SQL Query" and "Quick Select *" buttons will also
become available. The "Quick Select *" button will display the
results of performing a "Select * from {current table}. If -qlimit
was supplied on the command line, the number of results up to that
amount will be displayed. Otherwise all results are displayed. The "SQL
Query" button will bring up the SQL Query dialog. Again you can
either enter all of your SQL statements in the freeform window, or
use the command, fields, conditionals, and operators list to speed
your input. You can also save your query via the "Save" button and
use it again via the "Load" button.
Whenever a SQL statement is sent to the MySQL server, the Results
dialog will be displayed. If the statement doesn't result in any
returned results, the status line is used for this indication.
The status line is also used to issue minor error situations.
Please read the README file for command line options.
|
