Hi, Really, the SQL-2003 standard syntax would be nice (implementing non-recursive CTE is mostly trivial, btw): WITH moved_rows AS ( DELETE FROM products WHERE "date" >= '2010-10-01' AND "date" < '2010-11-01' RETURNING * ) INSERT INTO products_log SELECT * FROM moved_rows; On Thu, Jun 11, 2015 at 12:09 PM, Roberto Spadim <roberto@spadim.com.br> wrote:
+1, good idea, today i execute an insert, and a delete
2015-06-11 16:07 GMT-03:00 Geoff Montee <geoff.montee@gmail.com>:
Hi Rhys,
On Wed, Jun 10, 2015 at 1:23 AM, Rhys Campbell <Rhys.Campbell@tradingscreen.com> wrote:
" 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! ;-)
I don't know why you were chastised in the past, but I've added this to the JIRA:
https://mariadb.atlassian.net/browse/MDEV-8307
It sure sounds like a useful feature to me. Thanks for the suggestion!
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
-- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle
_______________________________________________ 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