Changes between Version 1 and Version 2 of ImportantUseCase2

Timestamp:

01/21/22 22:14:32 (2 years ago)

Author:

191151

Comment:

--

ImportantUseCase2

@@ -25 +25 @@
 UPDATE project.users
         SET email_verified_at = now(),updated_at = now()
-        WHERE id=11;
+        WHERE id = (
+                select u.id from users u
+                where u.email = 'test_organizer_1@mail.com'
+        );
+
 
 INSERT INTO project.organizers (user_id,city,country)
-        VALUES (11,'Skopje','North Macedonia');
+        VALUES ((
+                select u.id from users u
+                where u.email = 'test_organizer_1@mail.com'
+        ),'Skopje','North Macedonia');
 }}}