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!