Eloquent Upsert vs UpdateOrCreate: Practical Demo

Показать описание

For some Laravel forms, you need to update quite a lot of data, while also checking if it already exists. Let me show you 3 ways to do it in Eloquent.

Related links:

- - - - -
Support the channel by checking out our products:

Laravel Daily

Рекомендации по теме

Комментарии

Literally just ran into an issue with this today! Then found this video and it explained what we are doing wrong

noahbar-shain

THANK YOU! Some parts of the documentation couldn't be worse.

LuisEduardoBraschi

love how the explanation is made in details .

ramina

yeah, upsert is good ... I love upsert ... in the previous video, I'm comment suggest using upsert.

rudi

Awesome! This saved me hundreds of queries/updates. :-) Thank you!

dclindner

updateOrCreate() was my hero, but upsert() become my hero.

Irnovi

Now that's interesting, I didn't know SQL could do that on its own :D

Voltra_

$points = ($userPoints, $userId) => ['user_id' => $userId, 'points' => (int) $userPoints])->toArray();
would be better.

rahulday

Upsert doesn't work with primary keys ? I had a similar example of incrementing a field, but it would always try to insert new records

omkarjere

can you use wildcard variable inside the unique key?

elvenme

how can i get record was update or create after use upsert in laravel

chung

Thank you so much i just replacing my code. Thanks sir

anmolkaithwas

I think using unique would cause problems. Using the supplied laravel example of flights there would generally be many duplicate destinations with the departure being variable and vice versa. Looks like that requirement has since changed.

JohnvdVaart

if updateorcreate matches the date, how about it, sir, every new insert date doesn't update the data for the previous date

teknologikomunikasi

its great but how to find out how many entries have been updated and how many have been created

andrbee

to transform arrays I would use array_map()

soniablanche

hello in request validation i user it store but created_at And Update Ad Not Store AND what if i have $request->id ? how to store that id?

iamriwash

8.10.... Seems so long ago.
I don't remember when I first started using it.

Stoney_Eagle

Please am trying to upsert multiple rows but it's only inserting one row, please help

Onyecode

Nice thing! Is there a way to implement this in older versions like Laravel 7? Or to replicate this method. When you have thousand of records and you have to do a bulk update, this is a performance changer!

eusebiubalan

Eloquent Upsert vs UpdateOrCreate: Practical Demo

Eloquent Upsert vs UpdateOrCreate: Practical Demo

Eloquent Upsert vs UpdateOrCreate: Practical Demo

Laravel Eloquent | take care before using upsert method

Laravel Tutorial : Eloquent Upsert | UpdateOrCreate Data

part 7 update and create by one method laravel eloquent orm model | updateOrCreate vs upsert method

PHP : What is the differences between updateOrCreate() and updateOrInsert() in Laravel

Eloquent: Check Exists or Create New - Shortened

MySQL : Laravel updateOrCreate with auto-incremental database

laravel upsert #shorts

part 9 update insert by one laravel method | laravel query builder | updateOrInsert or upsert method

Laravel Eloquent Tips - Upserts in Eloquent

UPSERT in SQL Explained

Pro Tip to simplify your create or update operations in Laravel #laravel #shorts

Laravel: Mass Update Batch Rows in One Query? 3 Ways

Upsert Directive

Laravel 10 Fundamental [Part 103] - Eloquent ORM - firstOrCreate() and firstOrNew()

40. Understanding Upsert parameter in UpdateOne Method to insert or update document - MongoDB

How to use Laravel's updateOrCreate() method to create instance when ID is null? (2 Solutions!!...

Laravel Code Review - How to create a custom UPSERT method in your controller

Laravel Tutorials - Update and Upsert data using eloquent #13 | #hindi

How to use firstOrNew if it is first or new Laravel

Eloquent touch() and $touches: Update Timestamps

Update or Create a Course 1

The Eloquent Query Method: Batch updating (3/7)