/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 vote101 views1 answer
MySql count occurences more than"
SQL
0 vote105 views1 answer
Sql query to check if column contains alphabets
SQL
1 vote146 views1 answer
Ora-01950 no privileges on tablespace
SQL
0 vote92 views1 answer
Dnsmasq.conf location macos
SQL
3 votes99 views1 answer
Show index table
SQL
3 votes103 views4 answers
Mysql decimal
SQL
0 vote105 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
21 votes102 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
1 vote70 views1 answer
What are the cursors and what are the cursors types? in sql
SQL
0 vote95 views1 answer
Sql change primary key to composite key
SQL