How to Add Mediumblob Data Type using Laravel Migration?

Hi Dev,

Now, let's see an example of laravel migration mediumblob data type. We will use laravel mediumblob migration. This article goes in detailed on laravel migration mediumblob. step by step explain how to add mediumblob in laravel migration. So, let us see in detail an example.

Laravel migration provides only blob data type. IF you want to add Mediumblob column then you need to core sql query to add it using migration. I will create simple files table with mediumblob data type. so, let's see the simple example code:

Example:

Here, we will create files table with add Mediumblob to data type.

Create new migration using following command:

php artisan make:migration create_files_table

Now, You can update it as like the bellow:

database/migrations/migration_name.php

<?php
  
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
use Illuminate\Support\Facades\DB;
  
return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::create('files', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->string('mime');
            $table->timestamps();
        });
  
        DB::statement("ALTER TABLE files ADD file MEDIUMBLOB");
    }
    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        Schema::dropIfExists('files');
    }
};

Now, you are ready to run migration command:

php artisan migrate

You will see the layout as like the below:

I hope it can help you...