å¨å©ç¨æ°æ®åºå¼åæ¶ï¼å¸¸å¸¸ä¼å°ä¸äºè¡¨ä¹é´çæ°æ®äºç¸å¯¼å
¥ãå½ç¶å¯ä»¥ç¼åç¨åºå®ç°ï¼ä½æ¯ï¼ç¨åºå¸¸å¸¸éè¦å¼åç¯å¢ï¼ä¸æ¹ä¾¿ãææ¹ä¾¿æ¯å©ç¨sqlè¯è¨ç´æ¥å¯¼å
¥ãæ¢æ¹ä¾¿èä¿®æ¹ä¹ç®åã以ä¸å°±æ¯å¯¼å
¥çæ¹æ³ã
1ã 表ç»æç¸åç表ï¼ä¸å¨åä¸æ°æ®åºï¼å¦ï¼table1,table2)
Sql ï¼
å¤å¶ä»£ç 代ç å¦ä¸:
insert into table1 select * from table2 (å®å
¨å¤å¶)
insert into table1 select distinct * from table2(ä¸å¤å¶éå¤çºªå½ï¼
insert into table1 select top 5 * from table2 (åäºæ¡çºªå½)
2ãä¸å¨åä¸æ°æ®åºä¸ï¼å¦ï¼db1 table1,db2 table2)
sql:
[code]
insert into db1.table1 select * from db2.table2 (å®å
¨å¤å¶)
insert into db1.table1 select distinct * from db2table2(ä¸å¤å¶éå¤çºªå½ï¼
insert into tdb1.able1 select top 5 * from db2table2 (åäºæ¡çºªå½)
3ã表ç»æä¸åç表æå¤å¶é¨å纪å½ï¼å¦ï¼dn_user,dn_user2)
a. 建ä¸ä¸ªæ°è¡¨[DN_UserTemp]ï¼å¨è表dn_userä¸å¢å ä¸å)
温馨提示:内容为网友见解,仅供参考