Add multiple columns after a column in Laravel Migrations

#laravel #php #mysql

TRUNG VU May 14 ・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');
});

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');
    });
});