Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu07:loesungen:l02 [2024/10/01 09:22] – vdemir
+++ modul:m290:learningunits:lu07:loesungen:l02 [2024/10/17 12:44] (aktuell) – vdemir
@@ Zeile 1: / Zeile 1: @@
-====== LU07.S02 - INSERT INTO ======
+====== LU08.S02 - INSERT INTO ======
-===== Assignments =====
+===== A: Separate INSERT statements =====
-==== A: Separate INSERT statements ====
 Below you will find ten lines with employee data that you should insert into the ‘employees’ table, but with 10 separate INSERT commands.
@@ Zeile 29: / Zeile 27: @@
   VALUES (11, 'Ryan', 'Turner', '1991-05-21', 'M', 'He/Him', '2017-07-19', 70000.00, 'Marketing');
-==== B: One single INSERT statement ====
+===== B: One single INSERT statement =====
 ... Insert the following 20 lines of data into the table "employees".
@@ Zeile 54: / Zeile 52: @@
     (29, 'Oliver', 'Nelson', '1993-07-21', 'M', 'He/Him', '2018-11-19', 64000.00, 'Finance'),
     (30, 'Ava', 'Walker', '1958-02-11', 'F', 'She/Her', '2021-05-30', 52000.00, 'Marketing');
+ The result after the import of all 30 rows should look like in Webstorm the image below. As you can see, the select on the table "employees" returns 30 rows of data.
+{{:modul:m290:learningunits:lu07:loesungen:m290.lu07.s01c.png?800|}}