" This might be better suited as a feature request on the MariaDB JIRA."

I got chastised for doing that before so I'm trying to play nice! ;-)

-----Original Message-----
From: Geoff Montee [mailto:geoff.montee@gmail.com]
Sent: 09 June 2015 20:16
To: Rhys Campbell; MariaDB discuss
Subject: Re: [Maria-discuss] DELETE FROM RETURNING

Hi Rhys,

On Tue, Jun 9, 2015 at 8:29 AM, Rhys Campbell <Rhys.Campbell@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