开发者

how to load specific attributes from one table to another?

I am trying to load data from one tabl开发者_运维问答e to another. But I only need specific attributes from the table. For example,

I have two tables, Source(the table I am loading from) and Dest(the table I am putting the loaded data)

Source has ID, Birthyday, HometownAddress, CurrentAddress, Gender and Dest will include ID, Birthday and Gender.

How can I only load what I need to the Dest table?


insert into dest ( select id, birthyday from source )
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜