/SQL/How to insert multiple rows in mysql using laravel

How to insert multiple rows in mysql using laravel

/*
It is really easy to do a bulk insert in Laravel with or without the query builder.
You can use the following official approach.
*/


Entity::upsert([
    ['name' => 'Pierre Yem Mback', 'city' => 'Eseka', 'salary' => 10000000],
    ['name' => 'Dial rock 360', 'city' => 'Yaounde', 'salary' => 20000000],
    ['name' => 'Ndibou La Menace', 'city' => 'Dakar', 'salary' => 40000000]
], ['name', 'city'], ['salary']);

Source: laravel.com

Similar codes

3 votes286 views1 answer
Oracle apex warning message
SQL
5 votes302 views1 answer
Sort order on two columns sql
SQL
1 vote295 views1 answer
Multiple count in sql
SQL
31 votes310 views2 answers
Grant all priviledges to mysql user
SQL
0 vote305 views1 answer
Oracle sql number to varchar2
SQL
24 votes277 views5 answers
Sql reset auto increment
SQL
0 vote355 views1 answer
Sql check if field is not null
SQL
0 vote294 views1 answer
Oracle free up space in tablespace
SQL
0 vote343 views1 answer
Pl sql join 3 tables
SQL
6 votes286 views4 answers
Sqlite drop table
SQL