Laravel Migration Add Column After Column Example

By Hardik Savani November 5, 2023 Category : Laravel

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...

Tags :
Shares