Announcement

Collapse
No announcement yet.

How to delete fields from a database tables using phpmyadmin

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to delete fields from a database tables using phpmyadmin



    This tutorial is going to teach you how to delete fields from database tables using phpMyAdmin. We are going to assume that you are already logged into phpMyAdmin. For the purpose of this tutorial, we will use a database with one table for an example. The database will be listed in the left hand window, which is blue, with the table listed below it. The right hand window is where all the activity will take place.

    Let's get started on deleting fields from database tables using phpMyAdmin. Begin by selecting the table (from the left hand window) that you wish to delete fields from, and clicking on it. phpMyAdmin will bring up all the details about the table in the right hand window. You will see a list, in chart form, of the fields contained in the table. Find the field you wish to delete. In front of the field name, there is a check box. Mark this box. Then below the list you will find the Delete Icon. It is a big red X. Click on it. A screen will ask you to confirm that you really want to delete (or Drop) the Field? Click Yes to confirm. Now the phpMyAdmin window will show the list of table fields, and the deleted field is gone. phpMyAdmin also confirms that your action was successful.

    This is the end of this tutorial. You now know how to delete a field from database tables using phpMyAdmin.

    How to create a table in a database in phpmyadmin

    VodaHost

    Your Website People!
    1-302-283-3777 North America / International
    02036089024 / United Kingdom
    291916438 / Australia

    ------------------------

    Top 3 Best Sellers

    Web Hosting - Unlimited disk space & bandwidth.

    Reseller Hosting - Start your own web hosting business.

    Search Engine & Directory Submission - 300 directories + (Google,Yahoo,Bing)


Working...
X