ÎʸöSQLÓï¾äǶÌ×ÎÊÌ⣿ - Oracle / ¿ª·¢

1.insert into Auth_Base_NewNas(IPADDR,NODE,DOMAIN,FACTORYID) values('%s',%s,'%s',%s) 
2.select node from auth_base_orignasinfo where domain='HZ-YH-LP-1.DOMAIN'

Ôõô°Ñ2ÕÒµ½µÄnodeµÄÖµÌæ»»1ÖÐvaluesµÄnodeµÄÖµ£¬È»ºó²åµ½¿âÁË¡£

---

insert into Auth_Base_NewNas(IPADDR,NODE,DOMAIN,FACTORYID)
select '%s',node,'%s',%s
from auth_base_orignasinfo where domain='HZ-YH-LP-1.DOMAIN'

---

Â¥ÉÏÕý½â,ʹÓà insert....select.....

---

SQL code:

insert into Auth_Base_NewNas(IPADDR,NODE,DOMAIN,FACTORYID)
select '%s',node,'%s',%s from auth_base_orignasinfo
where domain='HZ-YH-LP-1.DOMAIN'

---

insert into auth_base_orignasinfo(IPADDR,NODE,DOMAIN,FACTORYID) select '220.191.154.221',node,'HZ-YH-LP-1.DOMAIN',4874 from auth_base_orignasinfo where domain='HZ-YH-LP-1.DOMAIN'

ÎÒÕâÑù²åʱ£¬ÌáʾID²»ÄÜΪ¿Õ£¬
insert into auth_base_orignasinfo(id,IPADDR,NODE,DOMAIN,FACTORYID) select 2,'220.191.154.221',node,'HZ-YH-LP-1.DOMAIN',4874 from auth_base_orignasinfo where domain='HZ-YH-LP-1.DOMAIN'

ÎÒÕâÑù²åʱ£¬ÌáʾORA-001£¬unique contrast....
²»ÖªµÀÔõô½â¾ö

---

ÄãµÄIDÊÇÖ÷¼üµÄ»°£¨²»ÔÊÐíÖظ´£©£¬Èç¹û±íÖÐÔ­À´Ã»ÓÐÊý¾Ý£¬¿ÉÒÔʹÓÃαÁÐrownum
insert into auth_base_orignasinfo(id,IPADDR,NODE,DOMAIN,FACTORYID) select rownum,'220.191.154.221',node,'HZ-YH-LP-1.DOMAIN',4874 from auth_bas