Laravel 9 - Create Column after Another Column

#laravel #webdev #migration #mysql

Notice: Only for MySQL.

If you're adding a new column to the existing table, it doesn't necessarily have to become the last in the list. You can specify after which column it should be created:

Schema::table('table', function (Blueprint $table) {
    $table->string('column')->after('column');
});

If you're adding a new column to the existing table, it doesn't necessarily have to become the last in the list. You can specify before which column it should be created:

Schema::table('table', function (Blueprint $table) {
    $table->string('column')->before('column_2');
});

If you want your column to be the first in your table , then use the first method.

Schema::table('table', function (Blueprint $table) {
    $table->string('column')->first();
});

Also the after() method can now be used to add multiple fields.

Schema::table('table', function (Blueprint $table) {
    $table->after('remember_token', function ($table){
        $table->string('column_1')->nullable();
        $table->string('column_2')->nullable();
    });
});