How to add new columns to an existing table in Laravel migration?

Web Development
,
1

I have an existing table in my database. I need to add multiple new columns to this table using a Laravel migration. The table name is transactions and I want to add vehicle_number and remarks columns, what’s the correct way to add those columns to the transactions table in Laravel?

2

Follow the steps below to add multiple columns to an existing table.
1. Create a new migration file using the artisan command.

artisan make:migration add_columns_to_transactions_table

Note: For better understanding you can name your migration like this add_vehicle_id_and_remarks_to_transactions_table.

2. Open the database/migrations directory, you will find a new migration file there. You need to modify both the up and down methods.

public function up()
{
    Schema::table('transactions', function (Blueprint $table) {
        $table->integer('vehicle_id');
        $table->string('remarks');
    });
}

And

public function down()
{
    Schema::table('transactions', function (Blueprint $table) {
        $table->dropColumn('vehicle_id');
        $table->dropColumn('remarks');
    });
}

3. Finally, run the migration to apply the changes to your database.

php artisan migrate