MySQL返回子句等效 [英] Mysql returning clause equivalent

问题描述

我是MySql的完全新手，所以请保持谦虚.

I am a complete newbie to MySql so please be gentle.

在Oracle中，是否等效于Oracle中的RETURNING子句，或者在MySQL中是否等效于SQL Server中的Inserted'/'Deleted表?我要执行的操作如下:

Is there an equivalent of the RETURNING clause in Oracle or the Inserted'/'Deleted tables in SQL Server in MySQL? What I want to do is the following:

• 从表A删除一组行

• 将已删除的行集插入表B.

• Delete a set of rows from table A

• Insert the deleted set of rows into table B.

请帮助！

谢谢

推荐答案

不幸的是，您不能在一个查询中同时进行插入和删除，但是您可以一次完成所有操作交易(如果您使用的是交易存储引擎(例如InnoDB)).此外，Oracle和PostgreSQL支持RETURNING，而MySQL不支持RETURNING，因此您需要编写单独的delete和insert语句.

Unfortunately, you can't do both insertion and deletion in one query, but you can do it all in one transaction if you are using a transactional store engine (like InnoDB). Moreover, RETURNING is supported by Oracle and PostgreSQL but not by MySQL and therefore you need to write separate delete and insert statements.

但是，使用事务将确保仅成功复制的数据将从tableA中删除.请考虑以下内容:

Using a transaction however, will guarantee that only the successfully copied data will be deleted from tableA. Consider the following:

begin transaction;
insert into tableB select * from tableA where 'your_condition_here';
delete from tableA where 'your_condition_here';
commit;

这篇关于MySQL返回子句等效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！