" 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