DEV Community

Cover image for Laravel 9 - Create Column after Another Column
Sandro Jhuliano Cagara
Sandro Jhuliano Cagara

Posted on

4 3

Laravel 9 - Create Column after Another Column

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');
});
Enter fullscreen mode Exit fullscreen mode

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');
});
Enter fullscreen mode Exit fullscreen mode

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();
});
Enter fullscreen mode Exit fullscreen mode

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();
    });
});
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Image of Docusign

🛠️ Bring your solution into Docusign. Reach over 1.6M customers.

Docusign is now extensible. Overcome challenges with disconnected products and inaccessible data by bringing your solutions into Docusign and publishing to 1.6M customers in the App Center.

Learn more