本文介绍了是否可以将记录从一个表转移到另一个表?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想删除一张表中的记录,同时我想将它们存储在其他表中 是否可能?如果是的话怎么样? 谢谢
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或更高版本,则可以这样做: technet.microsoft/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: technet.microsoft/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>
更多推荐
是否可以将记录从一个表转移到另一个表?
发布评论