How to Add Blob Data Type using Laravel Migration?

Hello Dev,

In this post, we will learn laravel migration blob. you will learn how to add blob data type in laravel migration. This example will help you laravel migration binary type. In this article, we will implement a laravel migration blog image store. So, let's follow a few steps to create an example of Laravel migration blob column.

Laravel migration provides binary() method to add mysql blob data type in laravel project. I will create simple products table with blob data type. so, let's see the simple example code:

Example:

Here, we will create products table with add Blob to data type.

Create new migration using following command:

php artisan make:migration create_products_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;
  
return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::create('products', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->text('description');
            $table->binary('image')->nullable(); 
            $table->timestamps();
        });
    }
  
    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        Schema::dropIfExists('products');
    }
};

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...