PHPackages ndexondeck/insert-on-duplicate-key - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. ndexondeck/insert-on-duplicate-key ActiveLibrary[Database & ORM](/categories/database) ndexondeck/insert-on-duplicate-key ================================== A trait for MySQL INSERT ON DUPLICATE KEY UPDATE forked from Yada Khov. v1.2.1(8y ago)1219MITPHP Since May 13Pushed 8y ago1 watchersCompare [ Source](https://github.com/ndexondeck/insert-on-duplicate-key)[ Packagist](https://packagist.org/packages/ndexondeck/insert-on-duplicate-key)[ Docs](https://github.com/ndexondeck/insert-on-duplicate-key.git)[ RSS](/packages/ndexondeck-insert-on-duplicate-key/feed)WikiDiscussions master Synced 1mo ago READMEChangelog (2)Dependencies (3)Versions (19)Used By (0) MySQL Insert On Duplicate Key Update Eloquent Trait =================================================== [](#mysql-insert-on-duplicate-key-update-eloquent-trait) [![Latest Stable Version](https://camo.githubusercontent.com/f3df2e9cd813595e40d890dc550b785fdb3f60dad4cd90d3981dea71b89746b0/68747470733a2f2f706f7365722e707567782e6f72672f796164616b686f762f696e736572742d6f6e2d6475706c69636174652d6b65792f76657273696f6e)](https://packagist.org/packages/ndexondeck/insert-on-duplicate-key)[![License](https://camo.githubusercontent.com/b714fe2d4a39841a45fee78cdd0d7a86cdf95cab9eab508135c7fdfc0bbed04e/68747470733a2f2f706f7365722e707567782e6f72672f796164616b686f762f696e736572742d6f6e2d6475706c69636174652d6b65792f6c6963656e7365)](https://packagist.org/packages/yadakhov/insert-on-duplicate-key)[![Build Status](https://camo.githubusercontent.com/0138cb6df72e44b3f4b341eae4eee5786baeaad86089a87bf58b9620cf1108f9/68747470733a2f2f7472617669732d63692e6f72672f796164616b686f762f696e736572742d6f6e2d6475706c69636174652d6b65792e737667)](https://travis-ci.org/yadakhov/insert-on-duplicate-key) [Insert Duplicate Key Update](http://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html) is a quick way to do mass insert. It's a trait meant to be used with Laravel's Eloquent ORM. ### Code Example [](#code-example) ``` use Illuminate\Database\Eloquent\Model; use Ndexondeck\InsertOnDuplicateKey; /** * Class User. */ class User extends Model { // The function is implemented as a trait. use InsertOnDuplicateKey; } ``` #### Multi values insert. [](#multi-values-insert) ``` $users = [ ['id' => 1, 'email' => 'user1@email.com', 'name' => 'User One'], ['id' => 2, 'email' => 'user2@email.com', 'name' => 'User Two'], ['id' => 3, 'email' => 'user3@email.com', 'name' => 'User Three'], ]; ``` #### INSERT ON DUPLICATE KEY UPDATE [](#insert-on-duplicate-key-update) ``` User::insertOnDuplicateKey($users); ``` ``` -- produces this query INSERT INTO `users`(`id`,`email`,`name`) VALUES (1,'user1@email.com','User One'), (2,'user3@email.com','User Two'), (3,'user3email.com','User Three') ON DUPLICATE KEY UPDATE `id` = VALUES(`id`), `email` = VALUES(`email`), `name` = VALUES(`name`) ``` ``` User::insertOnDuplicateKey($users, ['email']); ``` ``` -- produces this query INSERT INTO `users`(`id`,`email`,`name`) VALUES (1,'user1@email.com','User One'), (2,'user3@email.com','User Two'), (3,'user3email.com','User Three') ON DUPLICATE KEY UPDATE `email` = VALUES(`email`) ``` #### INSERT IGNORE [](#insert-ignore) ``` User::insertIgnore($users); ``` ``` -- produces this query INSERT IGNORE INTO `users`(`id`,`email`,`name`) VALUES (1,'user1@email.com','User One'), (2,'user3@email.com','User Two'), (3,'user3email.com','User Three'); ``` #### REPLACE INTO [](#replace-into) ``` User::replace($users); ``` ``` -- produces this query REPLACE INTO `users`(`id`,`email`,`name`) VALUES (1,'user1@email.com','User One'), (2,'user3@email.com','User Two'), (3,'user3email.com','User Three'); ``` ### created\_at and updated\_at fields. [](#created_at-and-updated_at-fields) created\_at and updated\_at will *not* be updated automatically. To update you can pass the fields in the insert array. ``` ['id' => 1, 'email' => 'user1@email.com', 'name' => 'User One', 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()] ``` ### Run unit tests [](#run-unit-tests) ``` ./vendor/bin/phpunit ``` ### Will this work on Postgresql? [](#will-this-work-on-postgresql) No. On Duplicate Key Update is only available on MySQL. Postgresql 9.4 has a similar feature called [UPSERT](https://wiki.postgresql.org/wiki/UPSERT). Implementing UPSERT is left as an exercise for the reader. ### Isn't this the same as updateOrCreate()? [](#isnt-this-the-same-as-updateorcreate) It is similar but not the same. The updateOrCreate() will only work for one row at a time which doesn't allow bulk insert. InsertOnDuplicateKey will work on many rows. ### Health Score 32 — LowBetter than 71% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity13 Limited adoption so far Community12 Small or concentrated contributor base Maturity72 Established project with proven stability Bus Factor1 Top contributor holds 61.5% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~29 days Recently: every ~4 days Total 18 Last Release 3159d ago Major Versions v0.1.0 → v1.0.02017-01-01 ### Community Maintainers ![](https://www.gravatar.com/avatar/aed511c0d6e2854f456ea87215c4fbfc3b3ab9a520df310e3bd43b4921acc3eb?d=identicon)[ndexondeck](/maintainers/ndexondeck) --- Top Contributors [![yadakhov](https://avatars.githubusercontent.com/u/146636?v=4)](https://github.com/yadakhov "yadakhov (16 commits)")[![ndexondeck](https://avatars.githubusercontent.com/u/15609182?v=4)](https://github.com/ndexondeck "ndexondeck (6 commits)")[![votemike](https://avatars.githubusercontent.com/u/3957065?v=4)](https://github.com/votemike "votemike (2 commits)")[![hibob224](https://avatars.githubusercontent.com/u/3732875?v=4)](https://github.com/hibob224 "hibob224 (1 commits)")[![kkomelin](https://avatars.githubusercontent.com/u/755066?v=4)](https://github.com/kkomelin "kkomelin (1 commits)") --- Tags databasemysqleloquent ### Code Quality TestsPHPUnit ### Embed Badge ![Health badge](/badges/ndexondeck-insert-on-duplicate-key/health.svg) ``` [![Health](https://phpackages.com/badges/ndexondeck-insert-on-duplicate-key/health.svg)](https://phpackages.com/packages/ndexondeck-insert-on-duplicate-key) ``` ### Alternatives [yadakhov/insert-on-duplicate-key A trait for MySQL INSERT ON DUPLICATE KEY UPDATE. 2762.9M6](/packages/yadakhov-insert-on-duplicate-key)[pecee/pixie Lightweight, fast query-builder for PHP based on Laravel Eloquent but with less overhead. 4128.7k8](/packages/pecee-pixie)[rah/danpu Zero-dependency MySQL dump library for easily exporting and importing databases 64401.8k10](/packages/rah-danpu)[moloquent/moloquent A MongoDB based Eloquent model and Query builder for Laravel (Moloquent) 120114.6k7](/packages/moloquent-moloquent)[sarfraznawaz2005/indexer Laravel package to monitor SELECT queries and offer best possible INDEX fields. 562.7k](/packages/sarfraznawaz2005-indexer)[zara-4/laravel-lazy-mysql A lazy mysql based Eloquent model and Query builder for Laravel 127.9k](/packages/zara-4-laravel-lazy-mysql) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)