Changes between Version 4 and Version 5 of UseCase06

Timestamp:

12/19/22 13:23:31 (2 years ago)

Author:

181085

Comment:

--

UseCase06

@@ -24 +24 @@
 ==== SQL 
 
-{{{#!sql
-
-INSERT INTO coordinates(latitude, longitude)
-VALUES  (41.990541334829416, 21.426715661049315);
-}}}
+''INSERT query за точка 3''
 
 {{{#!sql
 INSERT INTO request (city_address, street_address, number_address,  
-pick_up_coordinates_id, passenger_id)
+latitude, longitude, passenger_id)
 VALUES  ('Skopje', '8-mi Septemvri', 100, 
-        (SELECT coordinates_id FROM coordinates WHERE latitude=41.990541334829416),
+        41.990541334829416, 21.426715661049315,
         (SELECT passenger_id FROM passenger WHERE first_name='Marko'))
 }}}
+
+''SELECT query за точка 4''
 
 {{{#!sql