Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu07:loesungen:l02 [2024/10/01 09:16] – 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 ======
-===== Requirements  =====
+===== A: Separate INSERT statements =====
-  * Work type: Individual
-  * Timeframe: 15 Minutes
-  * Means of aid:
-      * Only teaching materials, no websearch, no use of ai.
-  * Expected Result:
-    * At least 30 rows of employees data, inserted into the **table employees**.
-    * 10 of the 30 rows are inserted with 10 separate insert statements.
-    * 20 of the 30 rows are inserted with one single SQL statement.
-===== Assignments =====
-==== 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.
- INSERT INTO EMPLOYEES (employee_id, name, surname, birthdate, sex, pronomen, employment_date, salary, department)
+  INSERT INTO EMPLOYEES (employee_id, name, surname, birthdate, sex, pronomen, employment_date, salary, department)
   VALUES (1, 'John', 'Doe', '1985-03-25', 'M', 'He/Him', '2015-01-15', 55000.00, 'Finance');
   INSERT INTO EMPLOYEES (employee_id, name, surname, birthdate, sex, pronomen, employment_date, salary, department)
@@ Zeile 39: / 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 64: / 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|}}