Bug #117915 support RETURNING clause
Submitted: 8 Apr 14:27 Modified: 8 Apr 14:52
Reporter: Vikram Rathod Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S4 (Feature request)
Version:8.x, 9.x OS:Any
Assigned to: CPU Architecture:Any

[8 Apr 14:27] Vikram Rathod 
Description:
It would be great if MYSQL could not support RETURNING clauses in the UPDATE statement.

It seems like databases like PostgreSQL and MariaDB support it. 

This feature, if provided, would work wonders to accomplish certain concurrent tasks that currently require some form of row locking using SELECT .. FOR UPDATE and other variants.

If there is anything I would need to know about this feature, Please do write back.

Thanks 

 
   

How to repeat:
It would be great if MYSQL could not support RETURNING clauses in the UPDATE statement.

It seems like databases like PostgreSQL and MariaDB support it. 

This feature, if provided, would work wonders to accomplish certain concurrent tasks that currently require some form of row locking using SELECT .. FOR UPDATE and other variants.

If there is anything I would need to know about this feature, Please do write back.

Thanks
[8 Apr 14:52] MySQL Verification Team 
Hello Vikram Rathod,

Thank you for the feature request!

regards,
Umesh