9 Jun
2015
9 Jun
'15
9:15 p.m.
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