maria-discuss team mailing list archive

[Rhys Campbell <Rhys.Campbell@xxxxxxxxxxxxxxxxx>]

" 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@xxxxxxxxx] 
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@xxxxxxxxxxxxxxxxx> 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