{"id":12628,"date":"2021-04-07T09:57:07","date_gmt":"2021-04-07T09:57:07","guid":{"rendered":"https:\/\/www.milesweb.in\/hosting-faqs\/?p=12628"},"modified":"2021-04-10T13:03:17","modified_gmt":"2021-04-10T13:03:17","slug":"modify-table-columns-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/","title":{"rendered":"How to Modify Table Columns in phpMyAdmin?"},"content":{"rendered":"<p><strong>Watch this video for a step by step process on how to Modify Table Columns in phpMyAdmin<\/strong><\/p>\n<div class=\"youtube-video\" style=\"border: 1px solid #ddd;\"><iframe src=\"https:\/\/www.youtube.com\/embed\/runOksKVjPY\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<p>phpMyAdmin is a tool that allows users to modify, alter and carry various other functions on MySQL and MariaDB databases. This tool is available on cPanel, Plesk and DirectAdmin as well.<\/p>\n<h2>To Modify Table Columns in phpMyAdmin<\/h2>\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>\u00a0from the list on the left side of your screen.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11323\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/04\/newsel_phpma_db.jpg\" alt=\"\" width=\"1638\" height=\"660\" \/> 4. A list of tables will appear. Click on the <strong>&#8216;+&#8217; icon <\/strong>beside the\u00a0table whose columns you want to modify.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11324\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/04\/newsel_phpma_table.jpg\" alt=\"\" width=\"1631\" height=\"708\" \/><\/p>\n<p>5. Click on the\u00a0 <strong>&#8216;+&#8217; icon <\/strong>beside\u00a0<strong>Columns<\/strong> to display the list of columns in the table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11321\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/04\/newsel_table_col.jpg\" alt=\"\" width=\"1734\" height=\"786\" \/><\/p>\n<p>6. A panel where you can enter and modify column attributes will appear. You can change the column&#8217;s name, field length(character limit), default value, and more.<\/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>: Changing certain things in the table columns may result in data loss or change. For example, if the field length is changed from 20 characters to 15 characters, all data in that column will get cut down to 15 characters.<\/p>\n<\/div>\n<\/div>\n<p>Once you have made all the modifications, click on <strong>Save<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11322\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/04\/newsave_mod_col.jpg\" alt=\"\" width=\"1918\" height=\"765\" \/><\/p>\n<p>phpMyAdmin will apply the changes and modify the table accordingly.<\/p>\n<p><script type=\"application\/ld+json\">{\n  \"@context\": \"http:\/\/schema.org\",\n  \"@type\": \"VideoObject\",\n  \"name\": \"How to Modify Table Columns in phpMyAdmin? | MilesWeb\",\n  \"description\": \"Here's an in-depth guide on how to modify table columns in phpMyAdmin: https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/ Give a thumbs up \ud83d\udc4d if you liked this video.  Subscribe to our channel and get notified for all the latest videos.  To know more about web hosting visit our website - https:\/\/www.milesweb.in\",\n  \"thumbnailUrl\": \"https:\/\/i.ytimg.com\/vi\/runOksKVjPY\/default.jpg\",\n  \"uploadDate\": \"2021-04-09T10:43:57Z\",\n  \"duration\": \"PT1M58S\",\n  \"embedUrl\": \"https:\/\/www.youtube.com\/embed\/runOksKVjPY\",\n  \"interactionCount\": \"8\"\n}<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Watch this video for a step by step process on how to Modify Table Columns in phpMyAdmin phpMyAdmin is a tool that allows users to modify, alter and carry various other functions on MySQL and MariaDB databases. This tool is available on cPanel, Plesk and DirectAdmin as well. To Modify Table Columns in phpMyAdmin 1. [&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,947],"tags":[2116,2115,629,1028,758],"class_list":["post-12628","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-database","category-howtos","category-phpmyadmin","tag-how-to-modify-table-columns-in-phpmyadmin","tag-modify-table-columns-in-phpmyadmin","tag-phpmyadmin","tag-phpmyadmin-database","tag-phpmyadmin-table"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Modify Table Columns using phpMyAdmin?<\/title>\n<meta name=\"description\" content=\"This article provides detailed instructions on how you can modify a table&#039;s columns in your MySQL or MariaDB databases 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.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Modify Table Columns using phpMyAdmin?\" \/>\n<meta property=\"og:description\" content=\"This article provides detailed instructions on how you can modify a table&#039;s columns in your MySQL or MariaDB databases via phpMyAdmin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2021-04-07T09:57:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-10T13:03:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.in\/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=\"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:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/\"},\"author\":{\"name\":\"Prasad Khartadkar\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e\"},\"headline\":\"How to Modify Table Columns in phpMyAdmin?\",\"datePublished\":\"2021-04-07T09:57:07+00:00\",\"dateModified\":\"2021-04-10T13:03:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/\"},\"wordCount\":214,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/04\/newsel_phpma_db.jpg\",\"keywords\":[\"How to Modify Table Columns in phpMyAdmin\",\"Modify Table Columns in phpMyAdmin\",\"phpmyadmin\",\"phpMyAdmin database\",\"PHPMyAdmin table\"],\"articleSection\":[\"Database\",\"How-Tos\",\"phpMyAdmin\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/\",\"name\":\"How to Modify Table Columns using phpMyAdmin?\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/04\/newsel_phpma_db.jpg\",\"datePublished\":\"2021-04-07T09:57:07+00:00\",\"dateModified\":\"2021-04-10T13:03:17+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e\"},\"description\":\"This article provides detailed instructions on how you can modify a table's columns in your MySQL or MariaDB databases via phpMyAdmin.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.in\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Modify Table Columns in phpMyAdmin?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.in\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e\",\"name\":\"Prasad Khartadkar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/08\/Prasad-K.-1-150x150.jpg\",\"contentUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/08\/Prasad-K.-1-150x150.jpg\",\"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.\",\"sameAs\":[\"https:\/\/www.milesweb.in\"],\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/author\/prasad-khartadkar\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Modify Table Columns using phpMyAdmin?","description":"This article provides detailed instructions on how you can modify a table's columns in your MySQL or MariaDB databases 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.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/","og_locale":"en_US","og_type":"article","og_title":"How to Modify Table Columns using phpMyAdmin?","og_description":"This article provides detailed instructions on how you can modify a table's columns in your MySQL or MariaDB databases via phpMyAdmin.","og_url":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2021-04-07T09:57:07+00:00","article_modified_time":"2021-04-10T13:03:17+00:00","og_image":[{"url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/04\/newsel_phpma_db.jpg","type":"","width":"","height":""}],"author":"Prasad Khartadkar","twitter_misc":{"Written by":"Prasad Khartadkar","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/#article","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/"},"author":{"name":"Prasad Khartadkar","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e"},"headline":"How to Modify Table Columns in phpMyAdmin?","datePublished":"2021-04-07T09:57:07+00:00","dateModified":"2021-04-10T13:03:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/"},"wordCount":214,"commentCount":0,"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/04\/newsel_phpma_db.jpg","keywords":["How to Modify Table Columns in phpMyAdmin","Modify Table Columns in phpMyAdmin","phpmyadmin","phpMyAdmin database","PHPMyAdmin table"],"articleSection":["Database","How-Tos","phpMyAdmin"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/","url":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/","name":"How to Modify Table Columns using phpMyAdmin?","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/04\/newsel_phpma_db.jpg","datePublished":"2021-04-07T09:57:07+00:00","dateModified":"2021-04-10T13:03:17+00:00","author":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e"},"description":"This article provides detailed instructions on how you can modify a table's columns in your MySQL or MariaDB databases via phpMyAdmin.","breadcrumb":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-table-columns-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.in\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How to Modify Table Columns in phpMyAdmin?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.in\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.in\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e","name":"Prasad Khartadkar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/08\/Prasad-K.-1-150x150.jpg","contentUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/08\/Prasad-K.-1-150x150.jpg","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.","sameAs":["https:\/\/www.milesweb.in"],"url":"https:\/\/www.milesweb.in\/hosting-faqs\/author\/prasad-khartadkar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/12628","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=12628"}],"version-history":[{"count":6,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/12628\/revisions"}],"predecessor-version":[{"id":12696,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/12628\/revisions\/12696"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=12628"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=12628"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=12628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}