digital
02-10-2006, 02:34 PM
When you install MySQL on your site, you basically create a blank database. In order to work on this database, you must add tables to it.
In order to add tables:
Click on the database in the left frame of the the phpMyAdmin page.
Enter the table name in the Name field, number of data fields which will be in the table in the Fields field. Click on the "go" button.
Enter the appropriate information in the fields to describe the data fields you are creating. For help, click on the Documentation link.
Once you have added all the information that you wish to add, click on the "save" button.
To work with the tables you have added:
After adding tables to your database, you will have more options available to you.
A listing of all of the tables within your database appears if you click on the plus sign in the left frame beside your database name.
You can open tables by clicking on the table name.
The fields and key of your table are listed along with various commands. These commands allow you to change or remove any field you choose, and to perform other actions.
Tools for working with the fields including Inserting data into the fields, are found underneath the Documentation link.
Other tools to work with your database are available from this page. Use the Documentation links for more information.
In order to add tables:
Click on the database in the left frame of the the phpMyAdmin page.
Enter the table name in the Name field, number of data fields which will be in the table in the Fields field. Click on the "go" button.
Enter the appropriate information in the fields to describe the data fields you are creating. For help, click on the Documentation link.
Once you have added all the information that you wish to add, click on the "save" button.
To work with the tables you have added:
After adding tables to your database, you will have more options available to you.
A listing of all of the tables within your database appears if you click on the plus sign in the left frame beside your database name.
You can open tables by clicking on the table name.
The fields and key of your table are listed along with various commands. These commands allow you to change or remove any field you choose, and to perform other actions.
Tools for working with the fields including Inserting data into the fields, are found underneath the Documentation link.
Other tools to work with your database are available from this page. Use the Documentation links for more information.