Question

www.un.org/Depts/DGACM/index_french.htm

网上数据输入<>Data表格,岗位上每小时将数据输入 燃<<>/strong>表格(该表保留Data 表格的缩略语,并迅速与数据库合作)。

我看到,有两个Psudo-SQL问题需要处理:

INSERT Archive SELECT * FROM Data;

以及

DELETE FROM Data;

然而,我只想删除成功复制的数据,如果复印件不成正文,我希望数据不会半分流,也不会删除。

这样做的正确途径是什么?

Answer 1

交易。

start transaction;
insert into archive select * from data;
delete from data where primary_key in (select primary_key from archive);
commit;

Answer 2

我建议使用多功能删除辛奈,并加入档案表删除。这样,你就只能删除两个表中的行文。

简单例子:

insert into archive select * from data;
delete data.*
from data
inner join archive on archive.id = data.id;

Beyond that, you may want to consider breaking this down into smaller chunks for better performance. For example:

insert into archive select * from data where id > 1000 and id <= 2000;
delete data.*
from data
inner join archive on archive.id = data.id
where data.id > 1000 and data.id <= 2000;

From the manual: http://dev.mysql.com/doc/refman/5.1/en/delete.html

友情链接