How I can make Laravel migration change and make column nullable

Question

I created a migration with post_id unsigned. How can I edit post_id in a new migration to also make it nullable()?

    Schema::create('throttle', function(Blueprint $table)
    {
        $table->increments('id');
        $table->integer('post_id')->unsigned(); // this needs to also be nullable, how should the next migration be?
    }

Does this answer your question? [Laravel Migration Change to Make a Column Nullable](https://stackoverflow.com/questions/24419999/laravel-migration-change-to-make-a-column-nullable) — miken32, Nov 19 '20 at 04:42

score 9 · Answer 1 · answered May 10 '18 at 07:05

9

Create migrate and add in your up function like this:

$table->integer('post_id')->nullable()->change();

answered May 10 '18 at 07:05

Truong Dang

3,119
1
15
21

1

Thank you too. Your answer also fixed my issue. – Fayyaz Ahmed May 10 '18 at 07:37

score -4 · Answer 2 · answered May 10 '18 at 06:59

-4

 php artisan migrate:rollback

change your migration

$table->integer('post_id')->nullable();

then

php artisan migrate

answered May 10 '18 at 06:59

Kuldeep Mishra

3,846
1
21
26

you can also set default value in nullable – Kuldeep Mishra May 10 '18 at 07:00
I already did. I am new here. It is giving me error when i click on up arrow – Fayyaz Ahmed May 10 '18 at 07:39
there is a accepet sign please accpet – Kuldeep Mishra May 10 '18 at 07:40
@KuldeepMishra Why you need accpet ? – Truong Dang May 10 '18 at 07:48
@TruongDang because i have answered successfully. – Kuldeep Mishra May 10 '18 at 07:52

How I can make Laravel migration change and make column nullable

2 Answers2