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 and laravel 9 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 IlluminateDatabaseMigrationsMigration;

use IlluminateDatabaseSchemaBlueprint;

use IlluminateSupportFacadesSchema;

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:

Laravel Migration Add Column After Column Example

i hope it can help you…

2 thoughts on “Laravel Migration Add Column After Column Example”

Leave a Comment