MySQL
Control Panel
The MySQL feature inside your Control Panel is
where you manage your database, design tables,
add, delete, and update records.
When you first click on the MySQL feature, you
will need to wait about 10 minutes for the
server to install and ready the database. Once
the database is created, you will receive the welcome
page for your database when you click on the
MySQL button. 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.
-
Browse
Display the records in the table 30 at a time. From the
Browse page you can edit or delete a record.
-
Select
Build and execute a SELECT query on the table. Only
those records which match the criteria you provide will
be displayed.
-
Insert
Add a new record to the table. Enter the data in the
fields provided. Various functions can be used to obtain
the current time, generate random numbers, and more.
Press the Save button to insert the record into the
table.
-
Properties
Display the fields in the table with their datatype and
attributes. Table management functions for the table are
also provided.
-
Drop
Remove the table and its contents from the database.
Once you do this neither the table nor the data will be
available.
-
Empty
Delete all of the records in the table. Once you do this
the table will still exits but the data in the table
will no longer be available.
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.
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.
References and Tutorials
|
