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");
}