/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 votes308 views2 answers
How to start mysql in terminal
SQL
0 vote304 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
2 votes297 views2 answers
Checking data type in sql server
SQL
0 vote316 views1 answer
Select * where id = 1,2,3
SQL
5 votes299 views1 answer
How to check port number for postgresql
SQL
0 vote312 views3 answers
Sql drop all tables
SQL
0 vote313 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote306 views1 answer
Connexion mysql
SQL
0 vote293 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote306 views1 answer
Check if database exists sql
SQL