Inserting fields into database tables with phpMyAdmin Print

  • 0

This tutorial is going to teach about the program phpMyAdmin, and how to Insert fields into database tables using phpMyAdmin. We will assume that you are already logged into phpMyAdmin. For the purposes of this tutorial, we will be using a database with two tables for our example.

Let's begin by locating the database name in the blue section on the left of the phpMyAdmin screen. Below that is the names of the two tables in our database. Select one of the tables by clicking on it. This will bring up all the details of the table in the white screen on the right hand side.

Below the table with the fields in it, you will see a section that begins with Print view. The next line is Add with a blank box for Fields. Place the number of fields you wish to add in the box. Then you need to choose where to add it. At End of Table, At Beginning of Table, or After with a pull-down menu, showing the fields you already have in your table. You select where you want to place the field by marking the radio button. When you are ready, click on the Go button.

This will take you to a screen where you need to give your new field values and types. For example, if you added an address field, the field would simply be address. The type would be CHAR (or character) and you might want to give it a length of at least 100, so that any length address would fit in the field. When you are done, click on the Save button. That will take you to a screen showing that the table has been altered, and giving the new list of table fields.

Click the Home button, below the phpMyAdmin name. This will return you to the main screen. This is the end of the tutorial. You now know how to add fields in a table using phpMyAdmin.

Was this answer helpful?

« Back


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


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


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