diff options
| author | Andrew <saintruler@gmail.com> | 2021-12-17 08:32:28 +0400 |
|---|---|---|
| committer | Andrew <saintruler@gmail.com> | 2021-12-17 08:32:28 +0400 |
| commit | 08759bd954b66aff9f63881b3ea5c7abcfc495fe (patch) | |
| tree | 4fcf3e54ae1b5415c04e50838b186579c701b2af /task6_triggers.sql | |
| parent | 15860fa29285ce48959f980dd44027f683f28b66 (diff) | |
Исправил шестую и седьмую лабы
Diffstat (limited to 'task6_triggers.sql')
| -rw-r--r-- | task6_triggers.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/task6_triggers.sql b/task6_triggers.sql index 3275880..20b1e6e 100644 --- a/task6_triggers.sql +++ b/task6_triggers.sql @@ -52,7 +52,7 @@ DROP TRIGGER RemoveDriverOnDelivery GO INSERT INTO Deliveries (driver_id, vehicle_id, route_id, date) -VALUES (1, 1, 1, '2021-09-08') +VALUES (1, 1, 1, '2021-04-15') GO UPDATE Deliveries @@ -154,7 +154,7 @@ DROP TRIGGER UpdateOrdersView GO UPDATE OrdersView -SET driver_id=2 +SET driver_id=1 WHERE order_date='2021-09-12' GO |