How to add new table in phpMyAdmin

How to add new table fields and insert row in phpMyAdmin using cPanel

1. The tutorial shows how to add new table, fields and insert some values.
2. First thing you need to do is go to http://www.yourdomain:2082
3. Login
4. Scroll down and click on phpMyAdmin
5. After that click on Database you wish to access
6. If there are no tables in the database click on Create Table
7. Enter you table name in first field
8. Now you are able to add fields
9. In the first column write for example id.
10. If you know that this value will be numberic, then select INT, otherwise you should choose TEXT. ID will always be numeric. (INT)
11. Check box AUTO_iINCREMENT, which means that each value can go from 0 to infinity.
12. In second field lets enter for example “name”
13. name does not contain numbers so we can choose text.
14. when you finish you can click on SAVE or add as many field as would like .
15. we can also add some default values for field called name. You should click on insert.
16. You are able to leave id field blank, because it has auto_invcrement value and will set as 1. If you will enter another one, it will set as 2 and so on.
17. When you finish you can click on Go.
18. You should click browse to see how many rows you have created.

click on full screen button to view video tutorial on full screen: