开发者

how to load specific attributes from one table to another?

开发者 https://www.devze.com 2023-04-08 03:58 出处:网络
I am trying to load data from one tabl开发者_运维问答e to another. But I only need specific attributes from the table.

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

精彩评论

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