UPDATE ... RETURNING

[Vikram Rathod]

Is there any way we can have the capability like UPDATE ... RETURNING in the existing MySQL 8.0+ like this https://www.postgresql.org/docs/current/dml-returning.html

We have a crucial query that we want to protect and the only way to do so now is to use a lock which causes a lot of contention problems to us.

We were trying to solve that but the only thing that prevented us from doing it cleanly without locks (explicitly locking) was update does have RETURNING-like feature.

So is there any other way we can achieve this? `SELECT FOR UPDATE` is something we are looking to avoid and it's a single ROWS hence we can't even `SELECT FOR UPDATE SKIP LOCKED`