The purpose of this article is to explain to you an approach to modify fields in database tables with phpMyAdmin. We will assume that you are signed in to phpMyAdmin. For the purpose of the article, we will use a database with one table for the illustration.
To begin, when you open the phpMyAdmin window, there are two sides. The left area is blue, and has the listing of databases and the tables they contain listed under them.
The other window is a white screen, and this is where all your working information will appear, along with details about your databases and tables when queried.
Let's learn how to modify fields in a database table, using phpMyAdmin. Pick on the table to modify by clicking on it. The right window will open up with the information of the table, including a list of all the fields in the table. Find the field you like to modify. Begin by putting a check mark in the box at the beginning of the field row. Then click on the Change icon, which is beneath the list, and looks like a pencil writing. This will open the chosen field line by itself, and you can at this point have the changes you need to make. Click on Save when you are done.
The right hand display will now show that the table has been successfully changed, and will show the alteration. You just click on the HOME button, which is in the left panel, below the phpMyAdmin name, and go back to the original screen. This will end this article. You already know how to modify the fields in a table using phpMyAdmin.
