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
Getting Started with Laravel in CodeLobster IDE
Getting Started with Laravel i...

Laravel is probably one of the most promoted PHP frameworks at the moment. It has a huge team and an excellent knowledge...

Read More

Jan-16-2022

Laravel 9 React JS CRUD Operation Example
Laravel 9 React JS CRUD Operat...

This article will show the laravel 9 react js crud operation example. Here, we will learn how to create crud operation i...

Read More

Dec-08-2022

Carbon Add Months To Date In Laravel
Carbon Add Months To Date In L...

In this article, we will see an example of carbon add months to date in laravel. Here, we will give you a simple&nb...

Read More

Dec-05-2020

Require ext-curl is missing from your system ubuntu
Require ext-curl is missing fr...

In this article, we will see require ext-curl * is missing from your system in ubuntu. When we set up the laravel 9...

Read More

Feb-16-2023