Using
The MySQL Control Panel
The
MySQL feature inside your Control Panel is where you manage
your database, including desiging tables, adding, deleting,
and updating records, all from within your web browser.
When
you first click on the MySQL feature, you will be asked
to provide a name for your database and a password, you
can use the same username and password that you use for
your Control Panel if you so desire. Once the database
is created, and you return to this feature inside your
Control Panel it will then become the Welcome page for
your database. A tree view is on the left. The name of
your database and the version of MySQL are displayed to
the right of the tree.
The
Tree
The
top entry in the tree, “Home,” will return
you to the Welcome page. Beneath that is your database
name and a square with a plus or minus sign in it. Clicking
the square will show and hide the names of the tables
in the database in the tree. Clicking on the database
name in the tree will display the main database management
page. Clicking on one of the tables names in the tree
will display the properties of that table.
The
Main Database Management Page
This
page displays a list of all the tables in your database
and the number of records in each. You can also execute
an SQL statement, perform advanced queries, dump the database,
and create new tables.
The
List of Tables
Next
to each table name are links to various actions you can
perform on a table.
Execute an SQL Statement
Any
SQL statement can be executed on your database by typing
it into the textbox labled “Run SQL query/queries
on database” and pressing the “Go” button.
For help with SQL statements ???
Query
by example
Advanced
queries can be built and executed using a graphical interface.
View
dump (schema) of database
Dumping
of the database displays the structure and or data contained
in the database. You can then save this information to
a file on your local computer for archiving or to aide
in the development of your database. The contents and
format of the dump are based on the radio button and check
box selections you make. See also View dump (schema) of
table.
Create
a new table
Create
a new table by typing in the name of the table and the
number of fields to be in the table and pressing the “Go”
button. You will be shown a page which will allow you
to set up the datatype and attributes of each field.
New
