{"id":10432,"date":"2021-04-07T11:04:14","date_gmt":"2021-04-07T11:04:14","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=10432"},"modified":"2024-04-23T12:25:02","modified_gmt":"2024-04-23T11:25:02","slug":"drop-columns-database-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/","title":{"rendered":"How to Drop Columns from a Database Using phpMyAdmin?"},"content":{"rendered":"<p>With phpMyAdmin, users can make alterations to their MySQL and MariaDB databases. This tool is available on cPanel, Plesk and DirectAdmin as well. You can even delete columns from a database via phpMyAdmin.<\/p>\n<h2>To Drop Columns from a Database Table via phpMyAdmin<\/h2>\n<div class=\"kb-wisdom-wrapr kb-wisdom-key kb-wisdom-wrapr-blue\">\n<div class=\"kb-wisdom-col kb-wisdom-col-icon\">\n<div class=\"kb-wisdom-icon\">\n<div><\/div>\n<\/div>\n<\/div>\n<div class=\"kb-wisdom-col kb-wisdom-col-content\">\n<p><strong>Note<\/strong>: Before beginning, we recommend you create a backup for the database as the following actions will result in the permanent loss of some data.<\/p>\n<\/div>\n<\/div>\n<p>1. Log in to your control panel(cPanel, DirectAdmin or Plesk) account.<\/p>\n<p>2. Browse and click on <strong>phpMyAdmin<\/strong>.<\/p>\n<p>3. The phpMyAdmin window will open. Select a <strong>database<\/strong> from the list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11323\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/04\/newsel_phpma_db.jpg\" alt=\"\" width=\"1638\" height=\"660\" \/><\/p>\n<p>4. Click on the <strong>&#8216;+&#8217; icon<\/strong> beside the table whose columns you wish to drop.<\/p>\n<p>5. Click on <strong>Columns<\/strong>. A panel showing the list of columns and functions will appear.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11328\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/04\/sel_col_table.jpg\" alt=\"\" width=\"1919\" height=\"713\" \/> 6. Tick beside the column you want to delete\/drop and then click <strong>Drop<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11330\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/04\/drop_col.png\" alt=\"\" width=\"1132\" height=\"318\" \/><\/p>\n<div class=\"kb-wisdom-wrapr kb-wisdom-warning kb-wisdom-wrapr-red\">\n<div class=\"kb-wisdom-col kb-wisdom-col-icon\">\n<div class=\"kb-wisdom-icon\">\n<div><\/div>\n<\/div>\n<\/div>\n<div class=\"kb-wisdom-col kb-wisdom-col-content\">\n<p><strong>Note<\/strong>: The Drop function permanently deletes the column and all its data from your database. You have to be sure that this action will not affect your database later as the data would be beyond recovery.<\/p>\n<\/div>\n<\/div>\n<p>7. A pop-up window will display the details of the column that is to be dropped. After confirming the details, Click <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11329\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/04\/del_ok.png\" alt=\"\" width=\"386\" height=\"196\" \/><\/p>\n<p>phpMyAdmin will delete the column from the table permanently.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>With phpMyAdmin, users can make alterations to their MySQL and MariaDB databases. This tool is available on cPanel, Plesk and DirectAdmin as well. You can even delete columns from a database via phpMyAdmin. To Drop Columns from a Database Table via phpMyAdmin Note: Before beginning, we recommend you create a backup for the database as [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[230,41,925],"tags":[2097,2095,2096,616,1008,726],"class_list":["post-10432","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-database","category-howtos","category-phpmyadmin","tag-delete-table-column-in-phpmyadmin","tag-drop-table-columns-in-phpmyadmin","tag-how-to-drop-table-columns-in-phpmyadmin","tag-phpmyadmin","tag-phpmyadmin-database","tag-phpmyadmin-table"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Drop Columns from a Database Using phpMyAdmin?<\/title>\n<meta name=\"description\" content=\"This article gives you instructions on how you can permanently delete\/drop columns from a database&#039;s table via phpMyAdmin.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Drop Columns from a Database Using phpMyAdmin?\" \/>\n<meta property=\"og:description\" content=\"This article gives you instructions on how you can permanently delete\/drop columns from a database&#039;s table via phpMyAdmin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2021-04-07T11:04:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-23T11:25:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/04\/newsel_phpma_db.jpg\" \/>\n<meta name=\"author\" content=\"Prasad Khartadkar\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prasad Khartadkar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/\",\"name\":\"How to Drop Columns from a Database Using phpMyAdmin?\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/04\/newsel_phpma_db.jpg\",\"datePublished\":\"2021-04-07T11:04:14+00:00\",\"dateModified\":\"2024-04-23T11:25:02+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e\"},\"description\":\"This article gives you instructions on how you can permanently delete\/drop columns from a database's table via phpMyAdmin.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Drop Columns from a Database Using phpMyAdmin?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e\",\"name\":\"Prasad Khartadkar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fafb102a39aa8f8d38a11f3e2dcfa746?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fafb102a39aa8f8d38a11f3e2dcfa746?s=96&d=blank&r=g\",\"caption\":\"Prasad Khartadkar\"},\"description\":\"Prasad is a business grad specialized in Marketing. He has garnered experience as a technical content writer and a digital marketer that he brings out in his work. He likes reading classics and travel in his free time.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/prasad-khartadkar\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Drop Columns from a Database Using phpMyAdmin?","description":"This article gives you instructions on how you can permanently delete\/drop columns from a database's table via phpMyAdmin.","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:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/","og_locale":"en_GB","og_type":"article","og_title":"How to Drop Columns from a Database Using phpMyAdmin?","og_description":"This article gives you instructions on how you can permanently delete\/drop columns from a database's table via phpMyAdmin.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2021-04-07T11:04:14+00:00","article_modified_time":"2024-04-23T11:25:02+00:00","og_image":[{"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/04\/newsel_phpma_db.jpg","type":"","width":"","height":""}],"author":"Prasad Khartadkar","twitter_misc":{"Written by":"Prasad Khartadkar","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/","name":"How to Drop Columns from a Database Using phpMyAdmin?","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/04\/newsel_phpma_db.jpg","datePublished":"2021-04-07T11:04:14+00:00","dateModified":"2024-04-23T11:25:02+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e"},"description":"This article gives you instructions on how you can permanently delete\/drop columns from a database's table via phpMyAdmin.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/drop-columns-database-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How to Drop Columns from a Database Using phpMyAdmin?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e","name":"Prasad Khartadkar","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fafb102a39aa8f8d38a11f3e2dcfa746?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fafb102a39aa8f8d38a11f3e2dcfa746?s=96&d=blank&r=g","caption":"Prasad Khartadkar"},"description":"Prasad is a business grad specialized in Marketing. He has garnered experience as a technical content writer and a digital marketer that he brings out in his work. He likes reading classics and travel in his free time.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/prasad-khartadkar\/"}]}},"views":431,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/10432","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=10432"}],"version-history":[{"count":3,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/10432\/revisions"}],"predecessor-version":[{"id":15393,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/10432\/revisions\/15393"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=10432"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=10432"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=10432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}