How to add new column after a custom column existing at the DB

Question

I want to add new Column with Migration after a custom column, for example I have this table structure:

And now I need to add a new column named badge after the prd_description (column 14).

So I ran php artisan make:migration add_badge_to_products_table --table=products

And here it goes:

public function up()
    {
        Schema::table('products', function (Blueprint $table) {
            $table->tinyInteger('badge')->unsigned()->nullable();
        });
    }

But now the problem is, I don't know how to add this column after that particular column. Because by default, Laravel adds this at the end of table.

So how to do this?

score 2 · Accepted Answer · answered Jun 30 '21 at 03:44

2

You need to use after method as bellow

public function up()
{
    Schema::table('products', function (Blueprint $table) {
        $table->tinyInteger('badge')->unsigned()->nullable()->after('prd_description');
    });
}

answered Jun 30 '21 at 03:44

parth

1,803
2
19
27

score 1 · Answer 2 · answered Jun 30 '21 at 03:44

add column after a single specific column Like,

  Schema::table('products', function (Blueprint $table) {
        $table->tinyInteger('badge')->after('prd_description')->unsigned()->nullable();
    });

Also Add Mulitple column Like this, https://laravel.com/docs/8.x/migrations#column-order

How to add new column after a custom column existing at the DB

2 Answers2