是否可以将记录从一个表转移到另一个表？ [英] is it possible to transfer the records from a one table to another table?

问题描述

我想删除一张表中的记录，同时我想将它们存储在其他表中

是否可能？如果是的话怎么样？

谢谢

i want to delete records in one table and at the same time i want to store them in other table
is it possible? if yes how?
thanks

推荐答案

我假设你在谈论SQL ...



如果您使用的是MSSQL 2005或更高版本，则可以这样做：

http://technet.microsoft.com/en-us/library/ms177564(v = sql.90）.aspx [ ^ ]



对于其他SQL，请尝试以下方法：

1.将表A中的新记录插入表B

2.从表A中删除记录

I assume you are talking about SQL...

If you are on MSSQL 2005 or later you may do this way:
http://technet.microsoft.com/en-us/library/ms177564(v=sql.90).aspx[^]

For other SQL try this:
1. insert new records form table A to table B
2. delete records from table A

你可以用Google搜索。



尝试这样..

you could have googled.

try like this..

insert into table2 select <column1,column2,.....> from table1 where <some condition>

delete table1 where <some condition>

这篇关于是否可以将记录从一个表转移到另一个表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！