/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 vote142 views1 answer
Sql create text column limited values
SQL
0 vote170 views1 answer
Oracle current date minus 1 day
SQL
1 vote152 views1 answer
Set statiscis on in ssms
SQL
1 vote147 views1 answer
Mysql remove last empty newline
SQL
0 vote129 views1 answer
Select value from previous row in postgresql
SQL
1 vote133 views1 answer
Importance of comment in mysql
SQL
0 vote187 views1 answer
Delete from table where length sql
SQL
0 vote150 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
0 vote152 views1 answer
Plpgsql if statement
SQL
0 vote150 views1 answer
Order by in codeigniter query builder
SQL