Portál AbcLinuxu, 25. dubna 2024 01:51
update ( select a2,b2 from tab1 inner join tab2 on a3=b3 ) set a2=b2
update tab1 set tab1.a2 = tab2.b2 from tab1 join tab2 on tab2.b3=tab1.a3
UPDATE tab1
SET a2 = COALESCE((
SELECT tab2.b2
FROM tab2
WHERE tab2.b3 = tab1.a3
LIMIT 1
), a2)
;
-- resp. pre velke tab1 a male tab2; s indexom na (a3)
UPDATE tab1
SET a2 = (
SELECT tab2.b2
FROM tab2
WHERE tab2.b3 = tab1.a3
LIMIT 1
)
WHERE a3 IN (
SELECT b3
FROM tab2
)
;
-- resp. pre male tab1 a velke tab2; s indexom na (b3,b2)
UPDATE tab1
SET a2 = (
SELECT tab2.b2
FROM tab2
WHERE tab2.b3 = tab1.a3
LIMIT 1
)
WHERE EXISTS (
SELECT 1
FROM tab2
WHERE b3 = a3
)
;
Tiskni Sdílej:
ISSN 1214-1267, (c) 1999-2007 Stickfish s.r.o.