Inserting Fields into Database Tables with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin

Now let’s learn how to Insert Fields into database tables

1. Select the Details table on the left

2. In this case, let’s choose to add an Address field AFTER the Name field

Insert Field in Database Table - phpMyAdmin - Details Table Add Field

3. Select the Type of filed – as an address can be a combination i.e alpha-numeric, select VARCHAR

Insert Field in Database Table - phpMyAdmin - Select Field Type

4. Enter the Length/Value maximum number of characters that you want to allow for this field.

5. Click Save when finished

Insert Field in Database Table - phpMyAdmin - Enter Field Length or Value

That’s it! Our Details table now has a new Address field

Insert Field in Database Table - phpMyAdmin - New Field Added

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

What Our Customers say..