现有的dabase表内容是否可以覆盖? [英] Is it possible existing dabase table content overide?

问题描述

DataBase1表A(此表中有一些数据)

DataBase2表B(此表中有一些数据)


表A中的数据不同，表B中的数据不同

我们需要将B表数据替换为A Tabe数据，这是否有可能

DataBase1 Table A (in this table have some data)

DataBase2 Table B ( in this table have some data)


Table A in Have diffrent data and Tabel B have Different Data

we need B table data overided with A tabe data is it possible

推荐答案

很简单.步骤是删除表B并将表记录A插入到B.示例SQL代码如下:

Pretty straight forward. Step is to drop table B and insert A table records into B. Sample SQL code is as:

----Clean Up target table B
DROP TABLE B

----Insert new records into target table
INSERT INTO B (FirstName, LastName)
SELECT FirstName, LastName
FROM A

----Verify that Data in B
SELECT FirstName, LastName FROM B

这篇关于现有的dabase表内容是否可以覆盖?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！