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;
|
