/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 vote152 views1 answer
Oracle job schedules
SQL
0 vote144 views1 answer
Oracle exchange partition
SQL
10 votes169 views6 answers
Mysql set root password
SQL
0 vote138 views1 answer
Selects all the columns from the sailors table
SQL
0 vote135 views1 answer
How to export table data from mysql table in sql format
SQL
-2 votes197 views3 answers
How to fetch first 10 rows in sql
SQL
5 votes129 views1 answer
Sql first day of current year
SQL
3 votes217 views1 answer
Sql add two values together
SQL
9 votes131 views1 answer
Mysql check date range
SQL
14 votes143 views2 answers
Oracle limit rows
SQL