{"id":228104,"date":"2024-06-19T09:20:43","date_gmt":"2024-06-19T09:20:43","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=228104"},"modified":"2024-06-19T09:20:43","modified_gmt":"2024-06-19T09:20:43","slug":"how-to-add-default-value-for-sql-in-laravel-2","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/","title":{"rendered":"How to add default value for SQL in Laravel?"},"content":{"rendered":"<p>Default values play an important role in SQL databases as they provide a fallback option when no explicit value is provided for a particular field. Laravel, a popular PHP framework, offers several ways to define default values for SQL columns. In this article, we will explore different methods to add default values to SQL in Laravel.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 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 \" >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:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#Method_1_Using_the_Schema_Builder\" title=\"Method 1: Using the Schema Builder\">Method 1: Using the Schema Builder<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#Method_2_Modifying_Existing_Table_Columns\" title=\"Method 2: Modifying Existing Table Columns\">Method 2: Modifying Existing Table Columns<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#Method_3_Using_Raw_SQL_Expressions\" title=\"Method 3: Using Raw SQL Expressions\">Method 3: Using Raw SQL Expressions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#Method_4_Using_Model_Level_Defaults\" title=\"Method 4: Using Model Level Defaults\">Method 4: Using Model Level Defaults<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#FAQs\" title=\"FAQs:\">FAQs:<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#Q1_Can_I_add_a_default_value_to_a_foreign_key_column\" title=\"Q1: Can I add a default value to a foreign key column?\">Q1: Can I add a default value to a foreign key column?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#Q2_How_can_I_remove_a_default_value_from_a_column\" title=\"Q2: How can I remove a default value from a column?\">Q2: How can I remove a default value from a column?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#Q3_Can_I_use_a_dynamic_expression_as_a_default_value\" title=\"Q3: Can I use a dynamic expression as a default value?\">Q3: Can I use a dynamic expression as a default value?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#Q4_Is_it_possible_to_have_different_default_values_for_different_rows_in_the_same_column\" title=\"Q4: Is it possible to have different default values for different rows in the same column?\">Q4: Is it possible to have different default values for different rows in the same column?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#Q5_What_happens_if_I_dont_provide_a_default_value_and_leave_it_as_null\" title=\"Q5: What happens if I don&#8217;t provide a default value and leave it as null?\">Q5: What happens if I don&#8217;t provide a default value and leave it as null?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#Q6_Can_I_change_the_default_value_of_a_column_later\" title=\"Q6: Can I change the default value of a column later?\">Q6: Can I change the default value of a column later?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#Q7_How_can_I_check_if_a_default_value_is_set_for_a_column_in_Laravel\" title=\"Q7: How can I check if a default value is set for a column in Laravel?\">Q7: How can I check if a default value is set for a column in Laravel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#Q8_How_can_I_add_a_default_value_for_a_boolean_column\" title=\"Q8: How can I add a default value for a boolean column?\">Q8: How can I add a default value for a boolean column?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#Q9_Can_I_use_constants_as_default_values\" title=\"Q9: Can I use constants as default values?\">Q9: Can I use constants as default values?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#Q10_Is_it_possible_to_have_a_default_value_that_depends_on_the_value_of_another_column\" title=\"Q10: Is it possible to have a default value that depends on the value of another column?\">Q10: Is it possible to have a default value that depends on the value of another column?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#Q11_Can_I_add_default_values_for_multiple_columns_at_once\" title=\"Q11: Can I add default values for multiple columns at once?\">Q11: Can I add default values for multiple columns at once?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#Q12_Can_I_change_the_default_value_of_an_existing_column_without_a_migration\" title=\"Q12: Can I change the default value of an existing column without a migration?\">Q12: Can I change the default value of an existing column without a migration?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Method_1_Using_the_Schema_Builder\"><\/span>Method 1: Using the Schema Builder<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The Schema Builder in Laravel allows developers to define database tables and their columns. To add a default value for an SQL column using the Schema Builder, you can use the `default` method. Here&#8217;s an example:<\/p>\n<p><code><br \/>\nSchema::create('users', function (Blueprint $table) {<br \/>\n    $table->string('name')->default('John Doe');<br \/>\n});<br \/>\n<\/code><\/p>\n<p>In the above example, the &#8220;name&#8221; column of the &#8220;users&#8221; table will have a default value of &#8220;John Doe&#8221; unless explicitly specified otherwise.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_2_Modifying_Existing_Table_Columns\"><\/span>Method 2: Modifying Existing Table Columns<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you need to add a default value to an existing column, you can use the `defaultTo` method in a migration file. Here&#8217;s an example:<\/p>\n<p><code><br \/>\nSchema::table('users', function (Blueprint $table) {<br \/>\n    $table->string('status')->default('active')->change();<br \/>\n});<br \/>\n<\/code><\/p>\n<p>In the above example, the existing &#8220;status&#8221; column of the &#8220;users&#8221; table will have a default value of &#8220;active&#8221; after the migration is executed.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_3_Using_Raw_SQL_Expressions\"><\/span>Method 3: Using Raw SQL Expressions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Laravel offers the flexibility to use raw SQL expressions while defining default values. This method can be useful if you need more complex default values. Here&#8217;s an example:<\/p>\n<p><code><br \/>\nSchema::create('products', function (Blueprint $table) {<br \/>\n    $table->integer('quantity')->default(DB::raw(0));<br \/>\n});<br \/>\n<\/code><\/p>\n<p>In the above example, the &#8220;quantity&#8221; column of the &#8220;products&#8221; table will have a default value of 0 using a raw SQL expression.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_4_Using_Model_Level_Defaults\"><\/span>Method 4: Using Model Level Defaults<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Another way to set default values in Laravel is by utilizing model level defaults. By defining default values in the model class itself, you can ensure that those values are applied whenever a new record is created. Here&#8217;s an example:<\/p>\n<p><code><br \/>\nclass Product extends Model<br \/>\n{<br \/>\n    protected $attributes = [<br \/>\n        'price' => 0.00,<br \/>\n        'quantity' => 0,<br \/>\n    ];<br \/>\n}<br \/>\n<\/code><\/p>\n<p>In the above example, the &#8220;price&#8221; and &#8220;quantity&#8221; attributes of the &#8220;Product&#8221; model will have default values of 0.00 and 0, respectively.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"FAQs\"><\/span>FAQs:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Q1_Can_I_add_a_default_value_to_a_foreign_key_column\"><\/span>Q1: Can I add a default value to a foreign key column?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can add a default value to a foreign key column. However, keep in mind that the value must exist in the referenced table.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q2_How_can_I_remove_a_default_value_from_a_column\"><\/span>Q2: How can I remove a default value from a column?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo remove a default value from a column, you can use the `change` method with the `default` parameter set to `null`.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q3_Can_I_use_a_dynamic_expression_as_a_default_value\"><\/span>Q3: Can I use a dynamic expression as a default value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can use dynamic expressions by using the `DB::raw` method to define the default value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q4_Is_it_possible_to_have_different_default_values_for_different_rows_in_the_same_column\"><\/span>Q4: Is it possible to have different default values for different rows in the same column?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, the default value applies to the entire column, not individual rows.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q5_What_happens_if_I_dont_provide_a_default_value_and_leave_it_as_null\"><\/span>Q5: What happens if I don&#8217;t provide a default value and leave it as null?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf a column is nullable and no default value is provided, the value will be null by default.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q6_Can_I_change_the_default_value_of_a_column_later\"><\/span>Q6: Can I change the default value of a column later?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can modify the default value of a column by creating a new migration to alter the column.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q7_How_can_I_check_if_a_default_value_is_set_for_a_column_in_Laravel\"><\/span>Q7: How can I check if a default value is set for a column in Laravel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThere is no direct method to check if a default value is set for a column. You can refer to the migration files or inspect the database schema to find out.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q8_How_can_I_add_a_default_value_for_a_boolean_column\"><\/span>Q8: How can I add a default value for a boolean column?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can use the `default` method with either `true` or `false` as the parameter value to set a default value for a boolean column.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q9_Can_I_use_constants_as_default_values\"><\/span>Q9: Can I use constants as default values?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can use constants as default values by referencing them directly in the column&#8217;s default value definition.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q10_Is_it_possible_to_have_a_default_value_that_depends_on_the_value_of_another_column\"><\/span>Q10: Is it possible to have a default value that depends on the value of another column?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, you cannot have a default value that depends on the value of another column. It can only be based on static values or expressions.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q11_Can_I_add_default_values_for_multiple_columns_at_once\"><\/span>Q11: Can I add default values for multiple columns at once?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can add default values for multiple columns in a single migration using the appropriate method for each column.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Q12_Can_I_change_the_default_value_of_an_existing_column_without_a_migration\"><\/span>Q12: Can I change the default value of an existing column without a migration?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, changing the default value of an existing column requires creating a migration file to modify the column&#8217;s definition.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Default values play an important role in SQL databases as they provide a fallback option when no explicit value is provided for a particular field. Laravel, a popular PHP framework, offers several ways to define default values for SQL columns. In this article, we will explore different methods to add default values to SQL in &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to add default value for SQL in Laravel?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#more-228104\">Read more<span class=\"screen-reader-text\">How to add default value for SQL in Laravel?<\/span><\/a><\/p>\n","protected":false},"author":57,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-228104","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learn","no-featured-image-padding"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to add default value for SQL in Laravel?<\/title>\n<meta name=\"description\" content=\"Default values play an important role in SQL databases as they provide a fallback option when no explicit value is provided for a particular field.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to add default value for SQL in Laravel?\" \/>\n<meta property=\"og:description\" content=\"Default values play an important role in SQL databases as they provide a fallback option when no explicit value is provided for a particular field.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/synchronyfinancial\" \/>\n<meta property=\"article:published_time\" content=\"2024-06-19T09:20:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Casey Mayer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@synchrony\" \/>\n<meta name=\"twitter:site\" content=\"@synchrony\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Casey Mayer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/\"},\"author\":{\"name\":\"Casey Mayer\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/89e431077ef417dfaa131f435124f18f\"},\"headline\":\"How to add default value for SQL in Laravel?\",\"datePublished\":\"2024-06-19T09:20:43+00:00\",\"dateModified\":\"2024-06-19T09:20:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/\"},\"wordCount\":707,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"articleSection\":[\"Learn\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/\",\"name\":\"How to add default value for SQL in Laravel?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-06-19T09:20:43+00:00\",\"dateModified\":\"2024-06-19T09:20:43+00:00\",\"description\":\"Default values play an important role in SQL databases as they provide a fallback option when no explicit value is provided for a particular field.\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to add default value for SQL in Laravel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"description\":\"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co\",\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/namso-gen.co\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"contentUrl\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"width\":500,\"height\":164,\"caption\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\"},\"image\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/synchronyfinancial\",\"https:\/\/twitter.com\/synchrony\",\"https:\/\/www.youtube.com\/synchronyfinancial\",\"https:\/\/www.instagram.com\/synchrony\",\"https:\/\/www.linkedin.com\/company\/synchrony-financial\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/89e431077ef417dfaa131f435124f18f\",\"name\":\"Casey Mayer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"caption\":\"Casey Mayer\"},\"description\":\"Guest author Casey Mayer has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to add default value for SQL in Laravel?","description":"Default values play an important role in SQL databases as they provide a fallback option when no explicit value is provided for a particular field.","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:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/","og_locale":"en_US","og_type":"article","og_title":"How to add default value for SQL in Laravel?","og_description":"Default values play an important role in SQL databases as they provide a fallback option when no explicit value is provided for a particular field.","og_url":"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2024-06-19T09:20:43+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png","type":"image\/png"}],"author":"Casey Mayer","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Casey Mayer","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/"},"author":{"name":"Casey Mayer","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/89e431077ef417dfaa131f435124f18f"},"headline":"How to add default value for SQL in Laravel?","datePublished":"2024-06-19T09:20:43+00:00","dateModified":"2024-06-19T09:20:43+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/"},"wordCount":707,"commentCount":0,"publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"articleSection":["Learn"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/","url":"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/","name":"How to add default value for SQL in Laravel?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-06-19T09:20:43+00:00","dateModified":"2024-06-19T09:20:43+00:00","description":"Default values play an important role in SQL databases as they provide a fallback option when no explicit value is provided for a particular field.","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-add-default-value-for-sql-in-laravel-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to add default value for SQL in Laravel?"}]},{"@type":"WebSite","@id":"https:\/\/namso-gen.co\/blog\/#website","url":"https:\/\/namso-gen.co\/blog\/","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","description":"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co","publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/namso-gen.co\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/namso-gen.co\/blog\/#organization","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","url":"https:\/\/namso-gen.co\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","contentUrl":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","width":500,"height":164,"caption":"Namso Gen Blog - Free Credit Card Generator [100% Valid]"},"image":{"@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/synchronyfinancial","https:\/\/twitter.com\/synchrony","https:\/\/www.youtube.com\/synchronyfinancial","https:\/\/www.instagram.com\/synchrony","https:\/\/www.linkedin.com\/company\/synchrony-financial"]},{"@type":"Person","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/89e431077ef417dfaa131f435124f18f","name":"Casey Mayer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Casey Mayer"},"description":"Guest author Casey Mayer has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here."}]}},"_links":{"self":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/228104","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/users\/57"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=228104"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/228104\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media\/107420"}],"wp:attachment":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media?parent=228104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=228104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=228104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}