INSERT INTO target
(id, name, location, flag,ad_org_id)
(
SELECT
s.id, s.name, s.location, s.flag,s.ad_org_id
FROM source s
)
ON CONFLICT (id,ad_org_id)
DO UPDATE
SET
name = excluded.name,
location = excluded.location,
flag=excluded.flag ;
Subscribe to:
Post Comments (Atom)
Kiro - Core Features
What is Kiro Kiro is an innovative AI-powered IDE that revolutionizes software development through intelligent assistance and structured wor...
-
Result Cache Stores the results of a query (Cloud Services) Same queries can use that cache in the future Table data has not changed Micro-p...
-
#Sample thislist = [ "apple" , "banana" , "cherry" ] print ( "MyList : " , thislist ) thislist...
-
CREATE INDEX sync_idx_abc ON schemaname.tablename(columnname);
No comments:
Post a Comment