Laravel Migration Add Column After Column Example

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 and laravel 10 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...