Laravel 10|9|8 Migration Add Column to Existing Table

Laravel add a column to existing table using migration example; In this tutorial, we will learn how to add a new columns to existing table using migration in laravel 10|9|8.

Sometimes there is a need to add new columns in your database tables. Today we will show you how to add new columns or columns to an existing table using Laravel migration.

How to Add Column to Existing Table using Migration in Laravel 10|9|8

Steps to add column to existing table using migration in laravel 10|9|8 apps:

• Add a single Column an existing table
• Add Multiple Columns in Existing Table
• Available Column Types

Let’s have a table called notes where the table you want to add notes type.

Add a single Column an existing table

To add a new column to the existing table using the laravel migration. Let’s open your terminal and create a migration file using the below command:

php artisan make:migration add_type_to_notes

It will create an add_type_to_notes file in the migration folder. It should be like this-

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class AddTypeToNotes extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('notes', function (Blueprint $table) {
            $table->string('note_type')->nullable();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('notes', function (Blueprint $table) {
            $table->dropColumn(['note_type']);
        });
    }
}

Run Migration Command

Run the below-given command in your terminal. It will add a new column to your table.

php artisan migrate

Now you can go to your database table and to see there a new column in your table. It has been added successfully using the migration command:

Add Multiple Columns in Existing Table

If you need to add multiple columns, you need to add the following command in the terminal.

php artisan make:migration add_multiple_column_to_notes

The above command will create a migration file, so go to database/migration folder and open your file and add column according to you:

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class AddMultipleColumnToNotes extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('notes', function (Blueprint $table) {
           $table->string('short_description')->nullable();
           $table->string('type')->nullable();
           $table->string('long_description')->nullable();

        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('notes', function (Blueprint $table) {
           $table->dropColumn(['short_description',  'type', 'long_description']);
        });
    }
}

Finally, run the below-given command for adding columns in your database table:

php artisan migrate

Available Column Types

Laravel schema builder has provided a variety of column types that you may specify when building your tables:

Conclusion

Laravel Migration example tutorial, in this tutorial you have learned how to add single or multiple columns in your database existing tables with example.

Recommended Laravel Tutorials