/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

0 vote348 views1 answer
Reset keys in sql
SQL
1 vote461 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote376 views1 answer
Sql select upcoming birthdays
SQL
0 vote349 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote368 views1 answer
How to update sql server version
SQL
0 vote395 views2 answers
Mysql dump database tables only
SQL
0 vote353 views2 answers
Wordpress change url in database
SQL
1 vote361 views2 answers
Postgres copy table from one schema to another
SQL
0 vote349 views1 answer
Match end of string regex sql
SQL
1 vote369 views1 answer
How to test for sql injection
SQL