PHP

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

add new column to table laravel

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

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

php artisan migrate

add column to migration laravel

php artisan make:migration add_profile_to_users

add column migration laravel

//exemple :
//php artisan make:migration add_new_column_to_my_table_table --table=my_table

//php artisan make:migration add_login_to_users_table --table=users

public function up()
{
    Schema::table('my_table', function($table) {
        $table->integer('new_column')->after('other_column_name');
      //with after it's better to place it in your table
    });
}

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

add new column in existing table in laravel migration

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

add new column in laravel migration

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

laravel add column to table

Schema::table('users', function (Blueprint $table) {
	$table->dateTime('verify_date')->nullable()->after("password_updated_at");
});

laravel 8 add column to existing table

#single migration file create command
php artisan make:migration add_delivery_time_to_carts_table --table=carts

how to add column to database in laravel

php artisan make:migration add_yourcolumnname --table="table_name"
  
Enjoy and HAPPY CODING

how to add colum in existing table laravel

**STEP 1**

    php artisan make:migration add_sex_to_users_table --table=users

**STEP 2**
In the new generated migration file, you will find up and down hook methods. in up hook, add there columns that you want to add, and in down hook, add there columns that you need to remove. for example, Me i need to add sex on column of users, so I will add there following line in the up hook.

    $table->integer('quantity')->default(1)->nullable();

So i have something like this

        public function up()
    {
        Schema::table('service_subscriptions', function (Blueprint $table) {
            $table->integer('quantity')->default(1)->nullable();
        });
    }

**STEP 3**
Run the migration command as follows

    php artisan migrate

Then you will have a new collumn added!!!!

THANK ME LATER!

laravel add column to table

// The table method on the Schema facade MAY BE USED TO UPDATE EXISTING TABLES.
// The table method accepts two arguments: the name of the table and a Closure
// that receives a Blueprint instance you may use to add columns to the table:
Schema::table('users', function (Blueprint $table) {
    $table->string('email');
});

create new column in Laravel migrations

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

add new column in existing table in laravel migration

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