diff options
Diffstat (limited to 'labs/2/run.sql')
| -rw-r--r-- | labs/2/run.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/labs/2/run.sql b/labs/2/run.sql index 3f32451..38aa0ef 100644 --- a/labs/2/run.sql +++ b/labs/2/run.sql @@ -95,3 +95,5 @@ CREATE TRIGGER update_sin AFTER UPDATE FOR EACH ROW WHEN (OLD.sin <> NEW.sin) EXECUTE PROCEDURE update_referenced_sin_numbers(); + +UPDATE departments SET dnumber = 14 where dnumber = 12; |