How to make default value null in laravel

Question

I'm making register form in laravel, first I create the migration

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateUsersTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->string('first_name');
            $table->string('last_name');
            $table->string('email')->unique();
            $table->string('password');
            $table->rememberToken();
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop('users');
    }
}

I want first to register name, email and password without first_name and last_name, but when I click register it gives me error that first_name and last_name don't have default values..so how to make default values null, because I want to update that columns later.

are you rolling back and running migration again or is a new migration to change the values? also which sql version do you have? — Jorge Y. C. Rodriguez
– Jorge Y. C. Rodriguez, Commented Nov 23, 2016 at 22:40

LorenzSchaef · Accepted Answer · 2016-11-23 22:14:33Z

23

$table->string('first_name')->default('DEFAULT');

edit: if the default value is supposed to be null, make it nullable instead.

$table->string('first_name')->nullable();

edited Nov 23, 2016 at 22:14

answered Nov 23, 2016 at 21:58

LorenzSchaef

1,54310 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Devmasta Over a year ago

it gives me again the same error, i've tried that before

LorenzSchaef Over a year ago

sorry. of course, if the default value should be null, you have to make the column nullable instead.

Devmasta Over a year ago

nothing, again the same error, i've tried default(null), nullable(), nullable()->default(null) and always the same..

Jason Seah Over a year ago

you did migrate:rollback and migrate again right ? can we have a look on the error message ?

Dasitha Abeysinghe · Accepted Answer · 2019-08-25 13:58:50Z

5

In Laravel 5.8 you can try it in migration script as below;

public function up()
{
    if (Schema::hasTable('table_name')) {
        Schema::table('table_name', function (Blueprint $table) {
            $table->string('column_name')->nullable();
        });
    }
}

Reference: https://laravel.com/docs/5.8/migrations

answered Aug 25, 2019 at 13:58

Dasitha Abeysinghe

4617 silver badges9 bronze badges

Comments

Marinario Agalliu · Accepted Answer · 2020-12-01 14:01:48Z

2

As per Laravel 8 there are 2 simple solutions.

If you want a default value instead of NULL you can do as follow in migration schema:

$table->string('total')->default('0');

This means that the default value will be 0.

If you want a NULL value you can do as follow in your schema: $table->string('total')->nullable();

Happy coding!

answered Dec 1, 2020 at 14:01

Marinario Agalliu

1,21713 silver badges31 bronze badges

Comments

Menisha Myelwaganam · Accepted Answer · 2021-01-06 05:55:43Z

2

I'm making register form in laravel, first I create the migration If you want a default value instead of NULL you can do as follow in migration schema:

$table->string('name')->nullable();

$table->string('name')->nullable()->default('NULL');

$table->string('name')->nullable()->default(NULL);

$table->string('name')->nullable()->default();

answered Jan 6, 2021 at 5:55

Menisha Myelwaganam

2663 silver badges28 bronze badges

Comments

Hedayatullah Sarwary · Accepted Answer · 2021-06-02 03:32:33Z

You can make first_name & last_name as nullable:

<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateUsersTable extends Migration {
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->string('first_name')->nullable();
            $table->string('last_name')->nullable();
            $table->string('email')->unique();
            $table->string('password');
            $table->rememberToken();
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop('users');
    }
}

When you use the nullable() method on a field, that field will default to NULL.

Максим Шинкаренко · Accepted Answer · 2020-02-23 13:50:44Z

0

->default('NULL')->nullable(true)

empirically...

answered Feb 23, 2020 at 13:50

Максим Шинкаренко

11 bronze badge

Collectives™ on Stack Overflow

How to make default value null in laravel

6 Answers 6

4 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

4 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related