mysql - 如何从 sql 文件中播种 laravel（包含指向其他 sql 文件的链接）

Question

我有两个文件

employees.sql

SELECT 'CREATING DATABASE STRUCTURE' as 'INFO';

DROP TABLE IF EXISTS employees_test;

CREATE TABLE employees_test (
    emp_no      INT             NOT NULL,
    first_name  VARCHAR(14)     NOT NULL,
    last_name   VARCHAR(16)     NOT NULL,
    hire_date   DATE            NOT NULL,
    PRIMARY KEY (emp_no)
);

SELECT 'LOADING employees_test' as 'INFO';
source employees.dump

employees.dump

INSERT INTO `employees_test` VALUES (10001,'Georgi','Facello','1986-06-26');

这个播种机不工作

<?php
use Illuminate\Database\Seeder;

class EmployeesSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
    $sql = base_path('database/seeds/temp/employees.sql');
    DB::unprepared(file_get_contents($sql));
    }
}

标签： mysqllaravellaravel-seeding