CODEWITHSUNDEEP
phpmysqllaraveleloquent
prgrm
prgrm

Reputation: 3833

Cannot insert a default entry in Laravel/Eloquent

I have this migration:

public function up()
{
    Schema::create('player', function (Blueprint $table) {

        $table->increments('id');
        $table->integer('victories')->default(0);
        $table->timestamps();

    });

    for($i = 0 ; $i < 6 ; $i++){
        DB::table('player')->insert([]);
    }
}

I want to insert 5 players, but Eloquent won't let me. It says that the insert function needs a parameter. This function works fine with other migrations where I actually need to input something in the array, but it won't work if it is empty.

Any help?

Upvotes: 0

Views: 46

Answers (1)

Ben
Ben

Reputation: 5129

Try:

for($i = 0 ; $i < 6 ; $i++) {
    DB::table('player')->insert(['id' => DB::raw('null')]);
}

Upvotes: 1

Related Questions