In using phpMyAdmin, you may have encountered a lot of challenges and you have been confused in managing databases and how to create tables within a certain database. For first time users, this can be a task that sounds very technical. The good news is that phpMyAdmin actually makes it very easy even for new users to accomplish.

PhpMyAdmin for MySQL is an extremely powerful tool. The interaction between these two programs will make account management hassle-free. Since phpMyAdmin supports many types of operations with MySQL, databases, tables, indexes, permissions, field management will not be as confusing as it may sound.

Databases usually have one or more tables where various types of information are recorded. You can add as much information as you want. In order to check the tables you already have within your database, check the left side of the screen once you log in. Your database is displayed in that area and the tables you have already created are shown below the database name. From there, you can view all the columns, rows and other fields that will help you retrieve data that you might need to use for many purposes.

The following demo & video tutorial will help you create a table within a database when you are logged in to phpMyAdmin. Here are the steps that you should follow:

1. Creating a table in database with phpMyAdmin.

2. Log in to phpMyAdmin. Select the demo1234_members database link.

3. Enter a name for the new table on the Name field.

4. Type in “details” on the Name field and then enter the number of fields the new table is to have on the Number of Fields box.

5. Type in “3” on the Number of Fields box and then click the Go button.

6. Enter the details of each field within the new table.

7. Type in “id” on the field column.

8. View the drop down menu in the Type column.

9. Select INT from the drop down menu in the Type column.

10. Type in “4” on the Length/Values column. We also want this field to be the primary key that will automatically filled in (auto_increment) when new entries are added to the table. The first field will be called “id” and it will be an integer that’s 4 characters in length.

11. Scroll over to the right side of the page

12. Type in “0” on the Default column. Selecting the Key icon will make the id field the primary key in the table.

13. Mark the Key icon.

14. The remaining fields will be CHAR (character) fields. Be sure the length is set long enough to accommodate the fields.

15. Type in “name” in the second row of the Field column.

16. Select the drop down menu in the Type column.

17. Select CHAR from the drop down menu in the Type column.

18. Type in “100” in the Length/Values column.

19. Type in “telephone” in the third row of the Field column.

20. View the drop down menu in the Type column.

21. Select CHAR from the choices in the drop down menu.

22. Type in “50” in the Length/Values column and then click the Save button once finished.

23. That’s it! Our new table (details) has been successfully created within our database (demo1234_members) as indicated here.

24. Click the Home icon.

25. This is the end of the video tutorial. You now know how to create new tables within a database using phpMyAdmin.

26. Thank you for watching our demo. Be sure to let us know if you have any questions.