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 )
加载中,请稍侯......
精彩评论