How to add new column in laravel migration without losing data

To add a new column in a Laravel migration without losing existing data, you can create a new migration file that alters the existing table. Laravel makes this easy using the php artisan make:migration command with the --table option.

Step-by-Step Guide:

You can generate a new migration

php artisan make:migration add_column_name_to_your_table_name_table --table=your_table_name

Replace column_name with your desired column, and your_table_name with the existing table.

You can edit the new migration file

Go to the newly created file in database/migrations/ and add the new column in the up() method.

public function up()
{
    Schema::table('your_table_name', function (Blueprint $table) {
        $table->string('new_column')->nullable(); // or you can define your data type here
    });
}

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

You can use Use ->nullable() if you want to avoid errors when adding the column to a table that already has data.

Don’t use ->default() unless you want to assign a default value.

Run the migration

php artisan migrate 

Notes:

This method preserves all existing data.

If the table has a lot of data and you’re on production, consider putting the site into maintenance mode first:

php artisan down
php artisan migrate
php artisan up

Example:
Adding a profile_picture column to the users table:

php artisan make:migration add_profile_picture_to_users_table --table=users 

Then, in the migration file:

public function up()
{
    Schema::table('users', function (Blueprint $table) {
        $table->string('profile_picture')->nullable();
    });
}

Then:

php artisan migrate

Your data will be safe, and the column will be added!

Let me know if you want to add multiple columns or modify column types as well.