UPDATE bobjects
SET object_id = ''
FROM bobjects BO
JOIN hosts H ON H.id = BO.host_id
WHERE H.type = 7
AND BO.object_id IS NULL
AND bobjects.id = BO.id;
Retrouvez, créez et partagez vos snippets en temps réel.
UPDATE bobjects
SET object_id = ''
FROM bobjects BO
JOIN hosts H ON H.id = BO.host_id
WHERE H.type = 7
AND BO.object_id IS NULL
AND bobjects.id = BO.id;
Créé il y a 2 mois.