aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/update/pre002223-1-naplo.sql
blob: 190c8eaba75525773a109cbe7d143b8975b6d60a (plain)
1
2
3
create temporary table _hianyzasr2223 select hianyzasId,oraId,tankorId,%INTEZMENYDB%.tankor.tankorTipusId from hianyzas LEFT JOIN ora USING (oraId) LEFT JOIN %INTEZMENYDB%.tankor USING (tankorId) where hianyzas.tankorTipusId is null;
create index hh on _hianyzasr2223 (hianyzasId);
update hianyzas SET tankorTipusId = (SELECT tankorTipusId FROM _hianyzasr2223 WHERE hianyzasId=hianyzas.hianyzasId) WHERE hianyzas.tankorTipusId IS NULL;