Laravel 10 Change Column Name And Type In Migration

Websolutionstuff | Apr-19-2023 | Categories : Laravel MySQL

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:

  • MySQL < 8.0.3
  • MariaDB < 10.5.2
  • SQLite < 3.25.0
Example:

You can rename the column names using the renameColumn() function in laravel 10.

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

 

Install Composer Package:

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

 

Change Data Type using Migration:

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()
    {
          
    }
}

 

Rename Column using Migration:

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:

Recommended Post
Featured Post
Carbon Add Months To Date In Laravel 9
Carbon Add Months To Date In L...

In this article, we will see carbon add months to date in laravel 9. Carbon provides the addMonth() and addMon...

Read More

Nov-18-2022

How To Create Parallax Scrolling Effect Using jQuery
How To Create Parallax Scrolli...

In this article, we will see how to create a parallax scrolling effect using jquery. Parallax scrolling is a websit...

Read More

May-04-2022

Laravel 8 Group By Query Example
Laravel 8 Group By Query Examp...

In this example we will see laravel 8 group by query example. how to use group by in laravel 8. As you might expect...

Read More

Nov-29-2021

Laravel 9 Has Many Through Relationship Example
Laravel 9 Has Many Through Rel...

In this article, we will see that laravel 9 has many through relationship example. hasManyThrough relationship is diffic...

Read More

Apr-04-2022