ItSolutionStuff.com

Hello,

In this example, you will learn laravel migration add column after column. I would like to share with you laravel migration add column after. This post will give you a simple example of how to add column after specific column in laravel migration. This tutorial will give you a simple example of laravel migration add column after specific column. Alright, let’s dive into the details.

In this example, I created a "posts" table and I want to add a new column status after the body column. I will use after() to add a column after a specific column in the table using laravel migration. you can easily set with laravel 6, laravel 7, laravel 8, laravel 9, laravel 10 and laravel 11 version.

so let's see bellow simple examples:

Create Migration Command:

php artisan make:migration add_new_columns_posts

Example 1: using after()

database/migrations/2023_01_16_134448_add_new_columns_posts.php

<?php
  
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
  
class CreateItemsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('posts', function($table)
        {
            $table->tinyInteger('status')->after('body');
        });
    }
 
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        	
    }
}

Now, you can run migration:

php artisan migrate

Output:

i hope it can help you...