Databases always consist of one or numerous tables with one or numerous fields and values. Each field also has varying types of data that needs to be inputted. PhpMyAdmin makes it easy, even for beginners, to create fields and tables for their databases.

Learn how to insert fields with database tables with phpMyAdmin below:

1. This tutorial will show you how to insert fields in database tables using phpMyAdmin.

2. Now let’s learn how to insert fields into database tables.

First, log in to your phpMyAdmin account. In your home page, click on the link that says “details” which can be found at the leftmost part of the page.

3. This will take you to the “Table: Details” page. In the “Propose Table Structure” option, choose if you want to add the field at the beginning of table, at the end of table, or after another field.
(In this case, let’s add an “address” field AFTER the “name” field)

4. Click on the check box for “after”.

5. Then click the drop down menu for the “after” field.

6. Choose and click on the “address” option.

7. Now click on the button that says “Go”.

8. You will be shown a page with several empty boxes. On the empty box labeled “Field”, type in the word “address”.

9. On the box labeled “Type”, click the drop down menu.

10. Find and choose the option that says “CHAR”.

11. On the next box labeled “Length/Values”, type in “100”. Then click on the button that says “Save” when finished.

12. You will see a message on your screen that says “Table details have been altered” and the SQL query box explaining the changes that have just been made. The “address” field can also now be seen in the table details.
That’s it. Your details table now has a new “address” field.

13. Click on the icon that shows “Home” to go back to your home page.

This is the end of the tutorial. You now know how to add fields in a table using phpMyAdmin.

14. Thank you for watching our video tutorial on how to add fields in a table with phpMyAdmin.

February 18, 2012 at 11:31 pm | No comment

This manual is a step by step guide on changing the name of existing database tables. Name changes are usually done to fit the description of a given data which is improperly titled.

So to find out how to rename database tables with phpMyAdmin look over the video tutorial & demo provide:

1. First, log in to phpMyAdmin.

2. To rename database tables, click the database table to be renamed. The database tables are listed at the left side of the window. Select one, for example click the “information” table link.

3. Click the “Operations” button located at the upper menu bar.

4. Scroll down and look for the table options box.

5. Beside the text “Rename table to,” click the text box.

6. Encode the new name of the database table, for this tutorial the name has been replaced with “infotable,” then click the “Go” button at the right hand corner of the box.

(A message saying that the table has been successfully renamed can then be viewed on the screen, at the same time the “information” table currently renamed to “infotable” can also be seen at the left side of the window.)

7. To return to the main menu, click the “Home” icon.

8. This is the end of the renaming database tables with phpMyAdmin demo and video tutorial.

9.Please contact us for any questions or suggestions on this matter. Thank you!

February 17, 2012 at 10:55 pm | No comment

On modifying fields in a database table, the user may change different field details according to the user’s preferences. The properties of the table that can be modified are the field’s name, type, length/value, and collation.

To learn how to modify fields in database tables with phpMyAdmin follow the steps given below:

1. To do this, the user is required to log in to a phpMyAdmin account.

2. To modify fields in database tables, select the “details” table located below the “demo1234_members (1)” link. A table will then appear.

3. To modify the “address” field, click the check box beside the “address” field. The selected field will then be highlighted.

4. Click the “change” icon. The change icon is the picture of a pencil below the “address” table.

5. Make the changes desired. To change the field name, click the text box and type the new field name. For this example, “address” has been changed to “city” and the length and/or value has been modified from “100” to “50.”

6. If all the modifications has been completed, click the “Save” button. A confirmation message will then appear along with the newly altered table, showing the changes that have been made.

7. Select the “Home” icon.

8. This is the end of the modifying fields’ video tutorial.

9. Please contact us for any queries you may have with this demo. Thank you!

February 16, 2012 at 10:42 pm | No comment

Deleting a table from a database with phpMyAdmin means dropping everything and anything inside the table, we will go through this in more detail with the video tutorial & demo below:

1. Sign in to an account in phpMyAdmin.

2. To delete a table from the database, select the table to be deleted at left side of the window. For this example, the tables that are available are “addresses” and “details.” Select the “addresses” link.

(The user will then be redirected to the addresses table wherein there are check boxes beside every field title. This allows the user to delete a specific field by ticking the check boxes and by clicking the delete button below. This is further discussed in a separate tutorial.)

3. To delete the entire table, click the “Drop” button or icon (the icon with a table and red “x” mark).

4. A small window will appear asking for table deletion confirmation, click “OK” to proceed. A message will appear saying that the table has been dropped from the database.

5. At the left side of the screen, click the “demo1234_members (1)” link. A page will then show that the addresses table does not exist in the database due to its absence in the file list.

6. To go back to the main menu, click the “Home” icon.

7. This concludes the table deletion video tutorial for phyMyAdmin.

8. Please contact us for any questions about this demo. Thank you!

February 15, 2012 at 10:34 pm | No comment

Deleting a field with phpMyAdmin’s database tables is very easy, follow the simple steps below to learn how to do it. Remember that deleting a file permanently removes it from the system, and recovery is not possible if no back up file has been created or saved separately.

Learn how to delete fields from database tables with phpMyAdmin with the demo below:

1. Sign in to phpMyAdmin.

2. To delete fields from database tables, select the “details” table at the left hand of the window.

3. A table will appear wherein the user may tick the box beside the field name. For this example check the “city” field. The “city” field will then be highlighted.

4. Click the “delete” or “drop” icon. This icon is a red “x” mark button below the table.

5. Click the “Yes” button to confirm the field deletion.

(The city field is now deleted in the database table. A message would confirm this, as it will be posted on the screen.)

6. Click the “home” icon or “house” picture to go back to the main menu of phpMyAdmin.

7. This is the end of the video tutorial on the procedure of deleting fields from database tables in phphMyAdmin.

8. Do let us know of any concerns and questions on this matter.

February 14, 2012 at 10:27 pm | No comment