# Implement INSERT/UPDATE/DELETE ... RETURNING

**URL:** <https://forums.percona.com/t/implement-insert-update-delete-returning/23673>\
**Category:** Percona Server for MySQL 8.0\
**Created:** [July 16, 2023, 6:20pm UTC](https://forums.percona.com/t/implement-insert-update-delete-returning/23673 "2023-07-16T18:20:36Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nunop](https://avatars.discourse-cdn.com/v4/letter/n/5fc32e/32.png) [@nunop](https://forums.percona.com/u/nunop)\
**Post date:** [July 16, 2023, 6:20pm UTC](https://forums.percona.com/t/implement-insert-update-delete-returning/23673/1 "2023-07-16T18:20:36Z")

</div>

Hey!

This is a nice feature that MariaDB has:

> **[INSERT...RETURNING](https://mariadb.com/kb/en/insertreturning/)**
>
> Returns a resultset of the inserted rows.

> **[DELETE](https://mariadb.com/kb/en/delete/#returning)**
>
> Delete rows from one or more tables.

Example usage:

`DELETE FROM table_sequence ORDER BY fid LIMIT 1 RETURNING fid`

Would be nice to support also something like:

`INSERT INTO ... ON DUPLICATE KEY UPDATE ... RETURNING xyz`

Would this be something you would consider? 🙂

Thank you very much!

---

<div class="post-metadata">

**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\
**Post date:** [July 17, 2023, 5:17am UTC](https://forums.percona.com/t/implement-insert-update-delete-returning/23673/2 "2023-07-17T05:17:59Z")

</div>

Hello @nunop,

Thank you for your suggestion and I’m not the right person to speak about feature implementation for Percona Server but I can surely guide you to an appropriate place to raise this.

Consider using this for raising bugs or in your case, feature request:  
[https://jira.percona.com](https://jira.percona.com)

Thanks,  
K

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [July 17, 2023, 2:45pm UTC](https://forums.percona.com/t/implement-insert-update-delete-returning/23673/3 "2023-07-17T14:45:23Z")

</div>

PostgreSQL has this as well (most likely from where MariaDB grabbed it). I can’t find it as an SQL standard though.

---

<div class="post-metadata">

**Author:** ![nunop](https://avatars.discourse-cdn.com/v4/letter/n/5fc32e/32.png) [@nunop](https://forums.percona.com/u/nunop)\
**Post date:** [July 23, 2023, 2:02pm UTC](https://forums.percona.com/t/implement-insert-update-delete-returning/23673/4 "2023-07-23T14:02:05Z")

</div>

Thanks @kedarpercona

Here it is: [[CLOUD-798] Implement INSERT/UPDATE/DELETE … RETURNING - Percona JIRA](https://jira.percona.com/browse/CLOUD-798)

Apologies - I might have unintentionally put in the wrong area! (“Cloud Dev”)

---

<div class="post-metadata">

**Author:** ![nunop](https://avatars.discourse-cdn.com/v4/letter/n/5fc32e/32.png) [@nunop](https://forums.percona.com/u/nunop)\
**Post date:** [July 24, 2023, 9:25am UTC](https://forums.percona.com/t/implement-insert-update-delete-returning/23673/5 "2023-07-24T09:25:15Z")

</div>

Feature Request was moved to the right place.

New link: [[PS-8850] Implement INSERT/UPDATE/DELETE … RETURNING - Percona JIRA](https://jira.percona.com/browse/PS-8850)