Modifying fields in database tables with phpMyAdmin Print

  • 0

The purpose of this tutorial is to teach you how to modify fields in database tables with phpMyAdmin. We will assume that you are logged in to phpMyAdmin. The purpose of the tutorial, we will use a database with one table for the example.

To begin, when you open the phpMyAdmin window, there are two sides. The left side is blue, and has the listing of database(s) and the tables they contain listed under them.
The other window is a white screen, and this is where all your working information will come up, along with details about your databases and tables when queried.

Let's learn how to modify fields in a database table, using phpMyAdmin. Select on the table to modify by clicking on it. The right window will open up with the details of the table, including a list of all the fields in the table. Find the field you wish to modify. Start by placing a check mark in the box at the beginning of the field row. Then click on the Change icon, which is below the list, and looks like a pencil writing. This will open the selected field line by itself, and you can now make the changes you need to make. Click on Save when you are done.

The right hand screen will now show that the table has been successfully altered, and will show the change. You can click on the HOME button, which is in the left panel, below the phpMyAdmin name, and return to the main screen. This will end this tutorial. You now know how to modify the fields in a table using phpMyAdmin.


Was this answer helpful?

« Back

SERVICES

ezyexchange  hosted microsoft exchange
ezytel  enterprise-grade hosted PBX
ezycloudsms  2-way cloud SMS
ezybroadband  NBN, wireless or fibre ethernet
ezy365  microsoft 365 licensing
ezywebhosting  enterprise web hosting
ezyssl  build trust, secure your brand
ezydomains  your name in the cloud
ezyreseller  our services, your clients


CONNECT

ezycloud | powered by Digital Hybrid
PO Box 7208, South Penrith, NSW, 2750


SALES & ENQUIRIES

Call   1300 882 942
SMS   0409 19 88 66


COPYRIGHT © 2009 -       Digital Hybrid Pty Ltd | really communicate       ACN 139 660 585   |   ABN 37 139 660 585   |   ALL RIGHTS RESERVED WORLDWIDE