/PHP/Laravel/Add new column in existing table in laravel migration

Add new column in existing table in laravel migration

Laravel migration add column to existing table

php artisan make:migration add_paid_to_users_table --table=users
  
public function up()
{
    Schema::table('users', function($table) {
        $table->integer('paid');
    });
}

public function down()
{
    Schema::table('users', function($table) {
        $table->dropColumn('paid');
    });
}

php artisan migrate

Source: stackoverflow.com

Add new column in existing table in laravel migration

php artisan make:migration add_paid_to_users_table --table=users

Source: stackoverflow.com

Laravel migration add column after

Schema::table('users', function ($table) {
    $table->string('email')->after('id')->nullable();
});

Add a new column to existing table in a migration

// for Laravel 5+
php artisan make:migration add_email_to_users_table --table=users

public function up()
{
    Schema::table('users', function($table) {
        $table->integer('email');
    });
}

public function down()
{
    Schema::table('users', function($table) {
        $table->dropColumn('email');
    });
}

php artisan migrate

Source: stackoverflow.com

Add new column in laravel migration

Schema::table('table_name', function (Blueprint $table) {
            $table->string('column_name', 255)->nullable()->after('previous_column_name');
        });

Add column to migration laravel

php artisan make:migration add_profile_to_users

Source: laravel-school.com

Similar codes

2 votes155 views2 answers
How get query from url in laravel
PHP Laravel
0 vote195 views1 answer
Laravel Excel numbers formatted as text still appearing as number
PHP Laravel
12 votes149 views6 answers
Laravel validation
PHP Laravel
0 vote157 views1 answer
Server error in laravel
PHP Laravel
28 votes160 views6 answers
Laravel make model with migration
PHP Laravel
0 vote139 views1 answer
Running a laravel app locally
PHP Laravel
12 votes155 views6 answers
Laravel model where
PHP Laravel
4 votes157 views1 answer
How to check query execution time in laravel
PHP Laravel
1 vote163 views1 answer
Laravel 8: seed users + Jetstream teams
PHP Laravel
0 vote137 views1 answer
Set laravel local time to indonesia
PHP Laravel