In this article, we will see laravel 10 change column names and data types in migration. Here, we will learn about migration column rename. Sometimes we need to change column name and data type after creating of migration so at that time this article is useful.
To rename a column, you may use the renameColumn
method provided by the schema builder.
So, let's see how to change column name in laravel 10 migration, laravel 10 migration change column type, and how to rename existing column name in laravel 10.
If you are running a database installation older than one of the following releases, you should ensure that you have installed the doctrine/dbal
library via the Composer package manager before renaming a column:
8.0.3
10.5.2
3.25.0
You can rename the column names using the renameColumn() function in laravel 10.
Schema::table('users', function (Blueprint $table) {
$table->renameColumn('from', 'to');
});
Now, we will install doctrine/dbal package using the following composer command.
composer require doctrine/dbal
Example:
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreatePostsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('posts', function (Blueprint $table) {
$table->bigIncrements('id');
$table->string('title');
$table->text('description');
$table->boolean('is_publish')->default(0);
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('posts');
}
}
Example:
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class ChangePostsTableColumn extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('posts', function (Blueprint $table) {
$table->longText('description')->change();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
}
}
Example:
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class ChangePostsTableColumn extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('posts', function (Blueprint $table) {
$table->renameColumn('title', 'name');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
}
}
You might also like:
In this article, we will see how to create a multi language website in laravel 9. In this example, we will see the...
Apr-20-2022
In this small post i will so you jquery search filter example. here we will see how to search data using jquery filter....
Aug-25-2021
In this example we will see laravel 8 order by query example. how to use order by in laravel 8.The orderBy met...
Dec-01-2021
Digital marketing is the component of marketing that utilizes internet and online bas...
Oct-19-2021