Forum How to insert multiple rows with one query?

posted 11 years ago

Database Eloquent

How would I implement this with laravel?

INSERT INTO table (a,b) VALUES (1,2), (2,3), (3,4);

thanks

Last updated 3 years ago.

replied 11 years ago

$values = array(
   array('field1' => 'value 1', 'field2' => 'value2', ...),
   ...
);

DB::table('tableName')->insert($value);

Last updated 3 years ago.

bajongthegreat bajongthegreat Joined 18 Apr 2014

We'd like to thank these amazing companies for supporting us

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Socials

The community