Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu07:theorie:04 [2024/09/30 16:01] – angelegt vdemir
+++ modul:m290:learningunits:lu07:theorie:04 [2024/10/17 13:49] (aktuell) – vdemir
@@ Zeile 1: / Zeile 1: @@
-====== LU07d - SQL-DML: DELETE ======
+====== LU08d - SQL-DML: DELETE ======
-** Sources:**
-  - [[https://www.w3schools.com/sql/sql_delete.asp | W3Schools | DELTE FROM ]]
-  - [[https://dev.mysql.com/doc/refman/8.4/en/delete.html | MySQL.COM | DELETE FROM ]]
-  - [[https://www.youtube.com/watch?v=OB2leB2iZ6U| Youtube | How to UPDATE and DELETE data from a TABLE ]]
-....
+**Sources:**
+  * [[https://www.w3schools.com/sql/sql_delete.asp | W3Schools | DELETE ]]
+===== 3. DELETE Statement =====
+The DELETE command is used to remove records from a table. Like UPDATE, it can be run with or without a filter, making it vital to define the condition to avoid unintended data removal.
 ===== DELETE with Filter (WHERE Clause) =====
-...
+Using a WHERE clause ensures that only specific rows matching the condition will be deleted.
-**Syntax**
+**Syntax:**
-  ....
+  DELETE FROM table_name
+  WHERE condition;
 **Example**
-  ...
+  DELETE FROM employees
+  WHERE employee_id = 1;
+===== DELETE without Filter =====
+Omitting the WHERE clause removes all data from the table, so it must be used cautiously. This operation doesn’t remove the table structure, just the rows.
+**Syntax:**
+  DELETE FROM table_name;
+**Example:**
+  DELETE FROM employees;
-===== DELTE without Filter =====
-....
-**Syntax**
-   ...
-**Example**
-  ...
 ==== Vocabulary ====
 ^English ^ Deutsch ^
 | ...| ... |
 ----
 [[https://creativecommons.org/licenses/by-nc-sa/4.0/|{{https://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png}}]] Volkan Demir