/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

17 votes191 views5 answers
Order by sql
SQL
5 votes197 views4 answers
Traduction
SQL
0 vote158 views1 answer
Tsql generate rows
SQL
0 vote185 views1 answer
Oracle table privileges
SQL
0 vote167 views2 answers
Sql join on wildcard
SQL
0 vote179 views1 answer
Get the next column of a table in mysql
SQL
0 vote198 views1 answer
How to print sql query
SQL
0 vote158 views1 answer
Difference between cross apply and inner join
SQL
1 vote182 views1 answer
Wordpress change http to https phpmyadmin
SQL
0 vote206 views1 answer
Psql store procedure-return multiple table values
SQL