{"id":522,"date":"2019-02-26T14:58:47","date_gmt":"2019-02-26T14:58:47","guid":{"rendered":"https:\/\/shujaahost.co.ke\/blog\/?p=522"},"modified":"2019-02-26T15:43:21","modified_gmt":"2019-02-26T15:43:21","slug":"dropping-columns-from-a-database-table-in-phpmyadmin","status":"publish","type":"post","link":"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/","title":{"rendered":"Dropping columns from a database table in phpMyAdmin"},"content":{"rendered":"\n<p>phpMyAdmin is one of the most popular and important application used to manage MySQL Database.  phpMyAdmin allows you to create, make changes, drop, delete, import or export MySQL Database tables. It also allows you to run MySQL queries and execute other MySQL Database management commands. In this tutorial, you will learn how to drop columns from a database in phpMyAdmin.<\/p>\n\n\n\n<p>Below are steps to follow while dropping columns:-<\/p>\n\n\n\n<h3 style='color:red; background-color:#fff1de; padding:2%'>Heads up! Dropping columns from a database table, deletes the column data and all the data in the column.<\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>You begin by accessing your phpMyAdmin via Cpanel<\/li><li>Go to your left side of the phpmyadmin, select the database that has the table you want to modify.<\/li><li>Inside the database you selected, you\u2019ll find all your database tables. Click on the <strong>structure link<\/strong> next to the name of the table that should be modified.<\/li><li>Place a check mark on the column you wish to drop\/delete.<\/li><li>Underneath the list of columns click on the Delete button.<\/li><li>Immediately you click it will ask you \u201cDo you really want to execute the following query?\u201d Counter check on what will be dropped to make sure it\u2019s the right column you are about to drop. If it is right column, click on the YES Button to continue. If otherwise then click NO Button.<\/li><li>When you click YES Button to continue, message stating your SQL query was executed successfully will be displayed meaning your columns has been dropped.<\/li><li><\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"<p>phpMyAdmin is one of the most popular and important application used to manage MySQL Database. phpMyAdmin allows you to create, make changes, drop, delete, import or export MySQL Database tables. It also allows you to run MySQL queries and execute other MySQL Database management commands. In this tutorial, you will learn how to drop columns ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-522","post","type-post","status-publish","format-standard","hentry","category-databases"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Dropping columns from a database table in phpMyAdmin - Shujaa Host<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dropping columns from a database table in phpMyAdmin - Shujaa Host\" \/>\n<meta property=\"og:description\" content=\"phpMyAdmin is one of the most popular and important application used to manage MySQL Database. phpMyAdmin allows you to create, make changes, drop, delete, import or export MySQL Database tables. It also allows you to run MySQL queries and execute other MySQL Database management commands. In this tutorial, you will learn how to drop columns ..Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Shujaa Host\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/shujaahostKenya\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-26T14:58:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-02-26T15:43:21+00:00\" \/>\n<meta name=\"author\" content=\"Cosmas Korir\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@shujaahost_ke\" \/>\n<meta name=\"twitter:site\" content=\"@shujaahost_ke\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Cosmas Korir\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/\"},\"author\":{\"name\":\"Cosmas Korir\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/person\/05c3cd0b767a65a164c5ed37c3edda59\"},\"headline\":\"Dropping columns from a database table in phpMyAdmin\",\"datePublished\":\"2019-02-26T14:58:47+00:00\",\"dateModified\":\"2019-02-26T15:43:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/\"},\"wordCount\":251,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#organization\"},\"articleSection\":[\"Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/\",\"url\":\"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/\",\"name\":\"Dropping columns from a database table in phpMyAdmin - Shujaa Host\",\"isPartOf\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#website\"},\"datePublished\":\"2019-02-26T14:58:47+00:00\",\"dateModified\":\"2019-02-26T15:43:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/shujaahost.co.ke\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dropping columns from a database table in phpMyAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#website\",\"url\":\"https:\/\/shujaahost.co.ke\/blog\/\",\"name\":\"Shujaa Host\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/shujaahost.co.ke\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#organization\",\"name\":\"Shujaa Host\",\"url\":\"https:\/\/shujaahost.co.ke\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/shujaahost.co.ke\/blog\/wp-content\/uploads\/2018\/10\/new-logo3-e1550211460915.png\",\"contentUrl\":\"https:\/\/shujaahost.co.ke\/blog\/wp-content\/uploads\/2018\/10\/new-logo3-e1550211460915.png\",\"width\":911,\"height\":770,\"caption\":\"Shujaa Host\"},\"image\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/shujaahostKenya\/\",\"https:\/\/x.com\/shujaahost_ke\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/person\/05c3cd0b767a65a164c5ed37c3edda59\",\"name\":\"Cosmas Korir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b163afca96bad97fe2edc180307eb19d?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b163afca96bad97fe2edc180307eb19d?s=96&r=g\",\"caption\":\"Cosmas Korir\"},\"sameAs\":[\"https:\/\/shujaahost.co.ke\"],\"url\":\"https:\/\/shujaahost.co.ke\/blog\/author\/cosmas\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Dropping columns from a database table in phpMyAdmin - Shujaa Host","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/","og_locale":"en_US","og_type":"article","og_title":"Dropping columns from a database table in phpMyAdmin - Shujaa Host","og_description":"phpMyAdmin is one of the most popular and important application used to manage MySQL Database. phpMyAdmin allows you to create, make changes, drop, delete, import or export MySQL Database tables. It also allows you to run MySQL queries and execute other MySQL Database management commands. In this tutorial, you will learn how to drop columns ..Read more","og_url":"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/","og_site_name":"Shujaa Host","article_publisher":"https:\/\/www.facebook.com\/shujaahostKenya\/","article_published_time":"2019-02-26T14:58:47+00:00","article_modified_time":"2019-02-26T15:43:21+00:00","author":"Cosmas Korir","twitter_card":"summary_large_image","twitter_creator":"@shujaahost_ke","twitter_site":"@shujaahost_ke","twitter_misc":{"Written by":"Cosmas Korir","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/#article","isPartOf":{"@id":"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/"},"author":{"name":"Cosmas Korir","@id":"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/person\/05c3cd0b767a65a164c5ed37c3edda59"},"headline":"Dropping columns from a database table in phpMyAdmin","datePublished":"2019-02-26T14:58:47+00:00","dateModified":"2019-02-26T15:43:21+00:00","mainEntityOfPage":{"@id":"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/"},"wordCount":251,"commentCount":0,"publisher":{"@id":"https:\/\/shujaahost.co.ke\/blog\/#organization"},"articleSection":["Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/","url":"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/","name":"Dropping columns from a database table in phpMyAdmin - Shujaa Host","isPartOf":{"@id":"https:\/\/shujaahost.co.ke\/blog\/#website"},"datePublished":"2019-02-26T14:58:47+00:00","dateModified":"2019-02-26T15:43:21+00:00","breadcrumb":{"@id":"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/shujaahost.co.ke\/blog\/dropping-columns-from-a-database-table-in-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/shujaahost.co.ke\/blog\/"},{"@type":"ListItem","position":2,"name":"Dropping columns from a database table in phpMyAdmin"}]},{"@type":"WebSite","@id":"https:\/\/shujaahost.co.ke\/blog\/#website","url":"https:\/\/shujaahost.co.ke\/blog\/","name":"Shujaa Host","description":"","publisher":{"@id":"https:\/\/shujaahost.co.ke\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/shujaahost.co.ke\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/shujaahost.co.ke\/blog\/#organization","name":"Shujaa Host","url":"https:\/\/shujaahost.co.ke\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/shujaahost.co.ke\/blog\/wp-content\/uploads\/2018\/10\/new-logo3-e1550211460915.png","contentUrl":"https:\/\/shujaahost.co.ke\/blog\/wp-content\/uploads\/2018\/10\/new-logo3-e1550211460915.png","width":911,"height":770,"caption":"Shujaa Host"},"image":{"@id":"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/shujaahostKenya\/","https:\/\/x.com\/shujaahost_ke"]},{"@type":"Person","@id":"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/person\/05c3cd0b767a65a164c5ed37c3edda59","name":"Cosmas Korir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b163afca96bad97fe2edc180307eb19d?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b163afca96bad97fe2edc180307eb19d?s=96&r=g","caption":"Cosmas Korir"},"sameAs":["https:\/\/shujaahost.co.ke"],"url":"https:\/\/shujaahost.co.ke\/blog\/author\/cosmas\/"}]}},"_links":{"self":[{"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/posts\/522","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/comments?post=522"}],"version-history":[{"count":8,"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/posts\/522\/revisions"}],"predecessor-version":[{"id":531,"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/posts\/522\/revisions\/531"}],"wp:attachment":[{"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/media?parent=522"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/categories?post=522"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/tags?post=522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}