laravel modify column migration code example

Example 1: laravel migration change column name

Schema::table('users', function (Blueprint $table) {
    $table->renameColumn('from', 'to');
});

Example 2: laravel migration rollback

To rollback one step:

php artisan migrate:rollback

To rollback multiple steps:

php artisan migrate:rollback --step=[x]
  
To drop all tables and reload all migrations:

php artisan migrate:fresh

Example 3: laravel create migration

php artisan make:migration add_votes_to_users_table --table=users

php artisan make:migration create_users_table --create=users

Example 4: migrations required field laravel

$table->string('foo')->nullable(false)->change();

Example 5: migrate to an existing table in laravel commad

php artisan make:migration add_paid_to_users_table --table=users

Example 6: laravel migration change column order

public function up()
{

    DB::statement("ALTER TABLE example MODIFY COLUMN foo DATE AFTER bar");

}

public function down()
{

    DB::statement("ALTER TABLE example MODIFY COLUMN foo DATE AFTER bar");

}

Tags:

Misc Example