Laravel - update is incrementing the ID?

Question

Hello guys,

I'm making an API using Laravel. In one of my scripts, I make an update on a field, like this :

user::where('uuid', $uuid)->update(['date' => $date]);

I noticed that the primary key increments when doing this. My obvious conclusion is that Eloquent makes a delete - insert in place of a regular MySQL update.

And so the question is, why ?

Thanks ahead.

Is will be good if you used Model to update the database table. — Sonu Sindhu, Dec 23 '15 at 10:59
And that's.... Not what I'm currently doing ? Sorry, Laravel beginner :) — Jeremy Belolo, Dec 23 '15 at 11:01
Would recommend you to change your field name date to created_at or others as there are date inbuilt function in mysql — Sonu Sindhu, Dec 23 '15 at 11:08
@SonuSindhu He clearly is using the model, and it doesn't matter that `date` is an inbuilt function since he's using eloquent. — Joel Hinz, Dec 23 '15 at 11:12
It's not possible primary key increments with this update (unless you have some DB triggers defined). You should analyse your code in details what exactly is being launched — Marcin Nabiałek, Dec 23 '15 at 11:28
It is also possible that you have some model events that when updating create new record and remove old one — Marcin Nabiałek, Dec 23 '15 at 11:47
@MarcinNabiałek you are right ! Didn't even think of this... If you want to put your comment as an answer I will accept it. Thanks ! — Jeremy Belolo, Dec 23 '15 at 13:30
@JeremyBelolo I've added answer, could you please tell me which guess was right - DB trigger or Laravel event? — Marcin Nabiałek, Dec 23 '15 at 13:43

score 1 · Accepted Answer · answered Dec 23 '15 at 13:43

It's not possible that this line of code will update id your records. Whenever you thing something strange happens in your application (not only in Laravel), you should:

analyse what exactly code is running that causes this problem (for example you think the error is in this line but you execute also some other custom function where error might occur)
verify if there are no extra framework dependant code launched - in this case events for user model
verify if there are no triggers in Database (that will automatically update/insert/delete records)

Laravel - update is incrementing the ID?

1 Answers1