2019-01-22
閱讀量:
887
如何將查詢的結(jié)果保存到數(shù)據(jù)庫(kù)?
如何將查詢的結(jié)果保存到數(shù)據(jù)庫(kù)?
答:分兩種情況,如果表已經(jīng)存在了
insert into somedatabase.sometable select distinct username,ddname,college,somedate,id from test_table where somedate>='20180101'and sdate<'20180130';
表不存在:
create table somedatabase.sometable as select distinct username,ddname,college,somedate,id from test_table where somedate>='20180101'and sdate<'20180130';






評(píng)論(0)


暫無(wú)數(shù)據(jù)
CDA考試動(dòng)態(tài)
CDA報(bào)考指南
推薦帖子
0條評(píng)論
0條評(píng)論
0條評(píng)論
0條評(píng)論