laravel migration alter table modify column code example
Example 1: laravel migration change column name
Schema::table('users', function (Blueprint $table) {
$table->renameColumn('from', 'to');
});
Example 2: create laravel migration
php artisan make:migration create_users_table
Example 3: migration rename column laravel
public function down()
{
Schema::table('posts', function (Blueprint $table) {
$table->renameColumn('user_id', 'author_ID');
});
}
Example 4: laravel change column
Schema::table('users', function (Blueprint $table) {
$table->string('name', 50)->nullable()->change();
});
Example 5: 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");
}