Hi Rhys,

On Tue, Jun 9, 2015 at 8:29 AM, Rhys Campbell
<rhys.campb...@tradingscreen.com> wrote:
>
> Just regarding the RETURNING feature introduced into MariaDB 10.0.5
> https://mariadb.com/kb/en/mariadb/delete/
>
> It would be useful, similar to the OUTPUT clause in MSSQL, if we could
> INSERT the data sent back from a returning clause in a single statement.
> Something likeā€¦
>
> CREATE TABEL deleted_ids
>
> (
>
>                 Id INT NOT NULL PRIMARY KEY
>
> );
>
> INSERT INTO deleted_ids
>
> DELETE FROM t1
>
> WHERE id < 999
>
> RETURNING id;
>

This might be better suited as a feature request on the MariaDB JIRA.
If you create an account, you should be able to submit it here:

https://mariadb.atlassian.net

Thanks,

Geoff

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to