{"id":8471,"date":"2020-12-10T04:01:00","date_gmt":"2020-12-10T04:01:00","guid":{"rendered":"https:\/\/ubiq.co\/tech-blog\/?p=8471"},"modified":"2025-08-29T04:44:21","modified_gmt":"2025-08-29T04:44:21","slug":"how-to-remove-default-value-of-column-in-mysql","status":"publish","type":"post","link":"https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/","title":{"rendered":"How to Remove Default Value of Column in MySQL"},"content":{"rendered":"\n<p>MySQL is a popular database used by many websites and organizations. It allows you to easily define automated rules called constraints. Among them, default constraint allows you to automatically set default values for MySQL columns, when new rows are created in a table. However, sometimes you may need to remove default constraint or drop default value in MySQL. In this article, we will look at how to remove default value of column in MySQL.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/#Why_Default_Values_Are_Important\" >Why Default Values Are Important<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/#How_to_Remove_Default_Value_of_Column_in_MySQL\" >How to Remove Default Value of Column in MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Why_Default_Values_Are_Important\"><\/span>Why Default Values Are Important<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Default value settings allow databases to automatically assign values to columns, even if no values are explicitly specified for them in INSERT statement. It provides many benefits such as:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Simplified data entry<\/strong> &#8211; It allows you to easily enter data automatically without actually specifying it in SQL queries. Even if you forget to mention the column in your INSERT query, MySQL will automatically populate it with default value. This avoids errors due to missing values. It is commonly used in transactional databases to record sign up, sale and order dates.<\/li>\n\n\n\n<li><strong>Maintain Data Integrity<\/strong> &#8211; Since columns with default values are always populated, whether they are explicitly mentioned or not, they are never blank. This constraint is really useful for columns that are foreign keys to maintain data integrity.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Remove_Default_Value_of_Column_in_MySQL\"><\/span>How to Remove Default Value of Column in MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>It is very easy to remove default constraint in MySQL. We will use ALTER TABLE statement with DROP DEFAULT clause to remove default value of column in MySQL.<\/p>\n\n\n\n<p>Here is the syntax to drop default constraint in MySQL<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt; ALTER TABLE table_name           \n       ALTER column_name DROP DEFAULT;<\/pre>\n\n\n\n<p>In the above query, you need to specify the table name and column name for which you want to remove default value.<\/p>\n\n\n\n<p>Here is an example to remove default constraint. Let us say you have the following database table where city column has default value equal to NYC&#8217;.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE TABLE employees (<br>    id int NOT NULL,<br>    name varchar(255) NOT NULL,<br>    age int,<br>    city varchar(255) DEFAULT 'NYC'<br>);<\/pre>\n\n\n\n<p>You can verify the constraint using SHOW TABLE or DESCRIBE TABLE statement.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt; describe employees;<br>+-------+--------------+------+-----+---------+-------+<br>| Field | Type         | Null | Key | Default | Extra |<br>+-------+--------------+------+-----+---------+-------+<br>| id    | int(11)      | NO   |     | NULL    |       |<br>| name  | varchar(255) | NO   |     | NULL    |       |<br>| age   | int(11)      | YES  |     | NULL    |       |<br><strong>| city  | varchar(255) | YES  |     | NYC     |       |<\/strong><br>+-------+--------------+------+-----+---------+-------+<\/pre>\n\n\n\n<p>Here is the SQL query to drop default constraint in MySQL.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt; ALTER TABLE employees       <br>       ALTER city DROP DEFAULT; <\/pre>\n\n\n\n<p>When you drop DEFAULT constraint, the column&#8217;s default value will revert to the standard default value for the column type. For example, for those columns that can contain null values, it will be NULL. Otherwise, it will be 0, empty string, or &#8216;0000-00-00&#8217; for numeric, string and date\/time\/datetime columns respectively. For columns having AUTO_INCREMENT constraint such as primary key columns, the default value will be sequentially next number.<\/p>\n\n\n\n<p>Similarly, you can also remove NOT NULL constraint in MySQL.<\/p>\n\n\n\n<p>If you do not want to completely drop the default constraint but only change the default value, then you can use the following statement.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt; ALTER TABLE employees<br>ALTER city SET DEFAULT 'San Francisco';<\/pre>\n\n\n\n<p>You can verify the changes using SHOW TABLE or DESCRIBE TABLE statement.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql&gt; describe employees;<br>+-------+--------------+------+-----+---------------+-------+<br>| Field | Type         | Null | Key | Default       | Extra |<br>+-------+--------------+------+-----+---------------+-------+<br>| id    | int(11)      | NO   |     | NULL          |       |<br>| name  | varchar(255) | NO   |     | NULL          |       |<br>| age   | int(11)      | YES  |     | NULL          |       |<br><strong>| city  | varchar(255) | YES  |     | San Francisco |       |<\/strong><br>+-------+--------------+------+-----+---------------+-------+<\/pre>\n\n\n\n<p>Please note, you do not need to drop default constraint in order to change it. Also, it will not update any of the existing column values, but only future values.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>It is important to note, that when you remove default value constraint from a column or change it, this will not update any of the existing rows. It will only disable assignment of default values in future INSERT statements. Also, it is important to analyze the implications of removing default constraint especially if it is foreign key or relationship.<\/p>\n\n\n\n<p>Need a reporting tool for MySQL? <a href=\"http:\/\/ubiq.co\/\">Ubiq<\/a>&nbsp;makes it easy to visualize data in minutes, and monitor in real-time dashboards.&nbsp;<a href=\"http:\/\/ubiq.co\/accounts\/register\">Try it<\/a>&nbsp;Today!<\/p>\n\n\n\n<p>Also read:<br><a href=\"https:\/\/ubiq.co\/tech-blog\/how-to-round-timestamp-in-mysql\/\">How to Round Timestamp in MySQL<\/a><br><a href=\"https:\/\/ubiq.co\/tech-blog\/how-to-rename-table-in-mysql\/\">How to Rename Table in MySQL<\/a><br><a href=\"https:\/\/ubiq.co\/tech-blog\/how-to-run-multiple-mysql-instances-on-same-machine\/\">How to Run Multiple Instances on Same Machine<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes you may need to remove default value in MySQL column. Here is how to remove default value of column in MySQL<\/p>\n","protected":false},"author":1,"featured_media":8474,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[324],"tags":[466],"class_list":["post-8471","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-remove-default-value"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Remove Default Value of Column in MySQL - Ubiq BI<\/title>\n<meta name=\"description\" content=\"Sometimes you may need to remove default value in MySQL column. Here is how to remove default value of column in MySQL\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Remove Default Value of Column in MySQL - Ubiq BI\" \/>\n<meta property=\"og:description\" content=\"Sometimes you may need to remove default value in MySQL column. Here is how to remove default value of column in MySQL\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Ubiq BI\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ubiqbi\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-10T04:01:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-29T04:44:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/12\/remove-default-value-in-mysql.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"730\" \/>\n\t<meta property=\"og:image:height\" content=\"410\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Sreeram Sreenivasan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@UbiqBI\" \/>\n<meta name=\"twitter:site\" content=\"@UbiqBI\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sreeram Sreenivasan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-remove-default-value-of-column-in-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-remove-default-value-of-column-in-mysql\\\/\"},\"author\":{\"name\":\"Sreeram Sreenivasan\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\"},\"headline\":\"How to Remove Default Value of Column in MySQL\",\"datePublished\":\"2020-12-10T04:01:00+00:00\",\"dateModified\":\"2025-08-29T04:44:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-remove-default-value-of-column-in-mysql\\\/\"},\"wordCount\":591,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-remove-default-value-of-column-in-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/remove-default-value-in-mysql.webp?fit=730%2C410&ssl=1\",\"keywords\":[\"remove default value\"],\"articleSection\":[\"MySQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-remove-default-value-of-column-in-mysql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-remove-default-value-of-column-in-mysql\\\/\",\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-remove-default-value-of-column-in-mysql\\\/\",\"name\":\"How to Remove Default Value of Column in MySQL - Ubiq BI\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-remove-default-value-of-column-in-mysql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-remove-default-value-of-column-in-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/remove-default-value-in-mysql.webp?fit=730%2C410&ssl=1\",\"datePublished\":\"2020-12-10T04:01:00+00:00\",\"dateModified\":\"2025-08-29T04:44:21+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\"},\"description\":\"Sometimes you may need to remove default value in MySQL column. Here is how to remove default value of column in MySQL\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-remove-default-value-of-column-in-mysql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-remove-default-value-of-column-in-mysql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-remove-default-value-of-column-in-mysql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/remove-default-value-in-mysql.webp?fit=730%2C410&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/remove-default-value-in-mysql.webp?fit=730%2C410&ssl=1\",\"width\":730,\"height\":410,\"caption\":\"remove default value in mysql\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-remove-default-value-of-column-in-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Remove Default Value of Column in MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#website\",\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/\",\"name\":\"Ubiq BI\",\"description\":\"Build dashboards &amp; reports in minutes\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\",\"name\":\"Sreeram Sreenivasan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"caption\":\"Sreeram Sreenivasan\"},\"description\":\"Sreeram Sreenivasan is the Founder of Ubiq. He has helped many Fortune 500 companies in the areas of BI &amp; software development.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/sreeram-sreenivasan\\\/\"],\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/author\\\/wordpress\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Remove Default Value of Column in MySQL - Ubiq BI","description":"Sometimes you may need to remove default value in MySQL column. Here is how to remove default value of column in MySQL","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:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/","og_locale":"en_US","og_type":"article","og_title":"How to Remove Default Value of Column in MySQL - Ubiq BI","og_description":"Sometimes you may need to remove default value in MySQL column. Here is how to remove default value of column in MySQL","og_url":"https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/","og_site_name":"Ubiq BI","article_publisher":"https:\/\/www.facebook.com\/ubiqbi","article_published_time":"2020-12-10T04:01:00+00:00","article_modified_time":"2025-08-29T04:44:21+00:00","og_image":[{"width":730,"height":410,"url":"https:\/\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/12\/remove-default-value-in-mysql.webp","type":"image\/webp"}],"author":"Sreeram Sreenivasan","twitter_card":"summary_large_image","twitter_creator":"@UbiqBI","twitter_site":"@UbiqBI","twitter_misc":{"Written by":"Sreeram Sreenivasan","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/#article","isPartOf":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/"},"author":{"name":"Sreeram Sreenivasan","@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc"},"headline":"How to Remove Default Value of Column in MySQL","datePublished":"2020-12-10T04:01:00+00:00","dateModified":"2025-08-29T04:44:21+00:00","mainEntityOfPage":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/"},"wordCount":591,"commentCount":0,"image":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/12\/remove-default-value-in-mysql.webp?fit=730%2C410&ssl=1","keywords":["remove default value"],"articleSection":["MySQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/","url":"https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/","name":"How to Remove Default Value of Column in MySQL - Ubiq BI","isPartOf":{"@id":"https:\/\/ubiq.co\/tech-blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/#primaryimage"},"image":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/12\/remove-default-value-in-mysql.webp?fit=730%2C410&ssl=1","datePublished":"2020-12-10T04:01:00+00:00","dateModified":"2025-08-29T04:44:21+00:00","author":{"@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc"},"description":"Sometimes you may need to remove default value in MySQL column. Here is how to remove default value of column in MySQL","breadcrumb":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/#primaryimage","url":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/12\/remove-default-value-in-mysql.webp?fit=730%2C410&ssl=1","contentUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/12\/remove-default-value-in-mysql.webp?fit=730%2C410&ssl=1","width":730,"height":410,"caption":"remove default value in mysql"},{"@type":"BreadcrumbList","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-remove-default-value-of-column-in-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ubiq.co\/tech-blog\/"},{"@type":"ListItem","position":2,"name":"How to Remove Default Value of Column in MySQL"}]},{"@type":"WebSite","@id":"https:\/\/ubiq.co\/tech-blog\/#website","url":"https:\/\/ubiq.co\/tech-blog\/","name":"Ubiq BI","description":"Build dashboards &amp; reports in minutes","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ubiq.co\/tech-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc","name":"Sreeram Sreenivasan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","caption":"Sreeram Sreenivasan"},"description":"Sreeram Sreenivasan is the Founder of Ubiq. He has helped many Fortune 500 companies in the areas of BI &amp; software development.","sameAs":["https:\/\/www.linkedin.com\/in\/sreeram-sreenivasan\/"],"url":"https:\/\/ubiq.co\/tech-blog\/author\/wordpress\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/12\/remove-default-value-in-mysql.webp?fit=730%2C410&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/pbGGTT-2cD","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/8471","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/comments?post=8471"}],"version-history":[{"count":3,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/8471\/revisions"}],"predecessor-version":[{"id":9346,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/8471\/revisions\/9346"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/media\/8474"}],"wp:attachment":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/media?parent=8471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/categories?post=8471"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/tags?post=8471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}