/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

1 vote380 views1 answer
Best configuration for display table in sqlplus
SQL
0 vote325 views1 answer
Sql get month from date
SQL
0 vote316 views1 answer
Sql server remove 0 from left
SQL
0 vote309 views1 answer
Find number of entries sql
SQL
4 votes346 views2 answers
Oracle unlock account
SQL
0 vote329 views1 answer
MySQL import data from large CSV file
SQL
1 vote312 views1 answer
Count of tables in database mysql
SQL
0 vote348 views1 answer
How to join result table in mysql
SQL
0 vote326 views1 answer
User defined variables in sql
SQL
0 vote311 views1 answer
Sql query to delete row by id
SQL