Laravel Add a new column to existing table in a migration

Step 1: Create a Migration

To begin, open your command line interface and navigate to your Laravel project directory. Run the following command to generate a new migration file:

php artisan make:migration add_column_to_table --table=table_name

Replace add_column_to_table with an appropriate name for your migration, and table_name with the name of the table to which you want to add a new column.

Also Read : How to create custom helper functions in Laravel

Step 2: Define the Column in the Migration File

Once the migration file is generated, open it using your preferred code editor. By default, the migration file will be located in the database/migrations directory. In the up method of the migration file, you can define the new column using the addColumn method provided by Laravel’s schema builder. Here’s an example:

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

class AddColumnToTable extends Migration
{
    public function up()
    {
        Schema::table('table_name', function (Blueprint $table) {
            $table->string('new_column');
        });
    }

    public function down()
    {
        Schema::table('table_name', function (Blueprint $table) {
            $table->dropColumn('new_column');
        });
    }
}

Replace table_name with the actual name of your table. In this example, we are adding a new column named new_column of type string. You can modify this according to your requirements.

Step 3: Run the Migration

To execute the migration and add the new column to the existing table, run the following command in your command line interface:

php artisan migrate

This command will run all pending migrations and apply the changes to the database.

Also Read: How to Set, Get, and Delete Cookies in Laravel 10

Step 4: Rollback (Optional)

If you need to rollback the migration and remove the newly added column, you can use the following command:

php artisan migrate:rollback

This command will undo the last batch of migrations, effectively removing the column added by the migration.

Conclusion:

In Laravel, migrations are a powerful tool for managing database schema changes. Adding a new column to an existing table is a common task during the development process, and Laravel’s migration system simplifies this process.

By following the steps outlined in this blog post, you can easily add a new column to an existing table using Laravel migrations. Remember to execute the migrations using the php artisan migrate command to apply the changes to your database.