DEV Community

TRUNG VU
TRUNG VU

Posted on

Add multiple columns after a column in Laravel Migrations

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:)

Top comments (0)