Hi,

Everyone, if you are new to phpMyAdmin,

Do read this tutorial as it will teach you about all of the basics of phpMyAdmin.

You can access
your MySQL account using phpMyAdmin using the link provided to you
-- in the Database section of HELM Control Panel.
When you click on the link just besides the name of the database, a
dialog box will prompt you for a username and password. This will be
the
username and password given you when we set it up for you.




Once you log in, a phpMyAdmin screen appears as shown below.



Creating a table in your database



The left-hand
frame in phpMyAdmin is used for navigation.You will see your
database displayed here (in this case called mydomain). As you create
tables, they will show below this.



Click on your
database the navigation frame and a new window will
appear on the
right hand side.



We will create a table in the database, called "people". Use the Create
new table
feature. Type in the name of the
new table
into the Name: people, and the number of columns in the table
(4) into Fields:.
This tutorial is only designed to show you the basic
php/MySQL/phpMyAdmin functions.
You can delete it using the Drop function. You will
want to allow for growth in your table.



Click Go and you should see something like this.
The table title now appears with under the database name.





Now enter the names and attributes of our table fields. Enter the
following
information as above:









Field
Type
Length
Default


Extra




id
int
6
0


auto_increment




name
char
100




telephone
char
50




birthday
char
50









The Length value indicates the maximum allowable length of
characters for input. There are many different
values that can be set for Type; see
further documentation here. The Types specified in this example
a