DEV Community

loading...

Add multiple columns after a column in Laravel Migrations

vumanhtrung profile image TRUNG VU ・1 min read

From Laravel 8.27 you can add multiple new columns after an existing column at the same time.

In previously, it isn’t difficult to write, you’d have to call after() method for each subsequent new column.

Schema::table('customers', function ($table) {
    $table->string('address_line1')->after('password');
    $table->string('address_line2')->after('address_line1');
    $table->string('city')->after('address_line2');
});
Enter fullscreen mode Exit fullscreen mode

From version 8.27 you can group them in a new after() method on the Blueprint migration instance.

Schema::table('customers', function ($table) {
    $table->after('password', function ($table) {
        $table->string('address_line1');
        $table->string('address_line2');
        $table->string('city');
    });
});
Enter fullscreen mode Exit fullscreen mode

Happy Coding:)

Discussion (0)

Forem Open with the Forem app