Modifying Fields in Database Tables with phpMyAdmin

0
202
database-phpmyadmin

PHPMyAdmin:

PhpMyAdmin is a free web application tool used by millions of users worldwide. It provides a user-friendly GUI for working with the MySQL database management system. phpMyAdmin can perform multiple tasks such as deleting, creating and modifying databases, fields, tables or rows, executing SQL statements or managing users and permissions. This tutorial will help you modify the fields in the database in phpMyAdmin.

Steps to Modify Fields in Database Table using phpMyAdmin:

Step 1: Log in to the cPanel of your website with valid credentials.

Step 2: Navigate to databases section and select the option PHPMyAdmin.

PhpMyAdmin Step 3: A new tab will open and select the database from the home page.

DB-nameDatabaseStep 4: Select the table from your database.

wp-user-table Step 5: Select the option Edit in each field which lists to modify an individual field. If you wish to modify the table details, select the Operations tab at the top of the screen.

Operations

Step 6: Make the necessary changes, then click the Go button to save it.

Modify-tables

Finally, the modification of the database has been done successfully. We hope that this tutorial will help you in Modifying fields in database tables with phpMyAdmin. For more information, follow us on Twitter and Facebook and For video tutorials, subscribe to our YouTube channel ServerCake India.

LEAVE A REPLY

Please enter your comment!
Please enter your name here