Hello Devs, 

In this tutorial, we will learn How to Run SQL File or query In Laravel Seeder?

Follow this step-by-step guide below. 


Example :

Create Seeder :

php artisan make:seeder SqlFileSeeder


database/seeds/SqlFileSeeder.php

<?php

use Illuminate\Database\Seeder;

class SqlFileSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {

        $path = public_path('sql/File.sql');
        $sql = file_get_contents($path);
        DB::unprepared($sql);
    }

}


Run Seeder:

php artisan db:seed --class=SqlFileSeeder


May this example help you.