/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

50 votes193 views6 answers
Sql duplicate rows
SQL
0 vote178 views1 answer
Limit and offset in stored procedure mssql
SQL
14 votes188 views3 answers
Alter foreign key
SQL
11 votes177 views3 answers
Sqlite3 create table from another table
SQL
3 votes173 views2 answers
Oracle grants
SQL
2 votes212 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote191 views1 answer
Get last three characters in mysql column
SQL
0 vote216 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
0 vote180 views1 answer
Best sql collation
SQL
1 vote138 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL