MariaDB's JIRA has moved to jira.mariadb.org. This instance of JIRA has been disabled. You can use your same credentials to log in to the new JIRA!
It would be great if MariaDB supported SQL standard Common Table Expressions (CTEs).
WITH moved_rows AS (
DELETE FROM products
"date" >= '2010-10-01' AND
"date" < '2010-11-01'
INSERT INTO products_log
SELECT * FROM moved_rows;
[PATCH] Implement non-recursive common table expressions