Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
| Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
| modul:m290:learningunits:lu07:theorie:03 [2024/09/30 13:03] – vdemir | modul:m290:learningunits:lu07:theorie:03 [2024/10/17 12:45] (aktuell) – vdemir | ||
|---|---|---|---|
| Zeile 1: | Zeile 1: | ||
| - | ====== | + | ====== |
| ** Sources:** | ** Sources:** | ||
| - [[https:// | - [[https:// | ||
| Zeile 20: | Zeile 20: | ||
| WHERE employee_id = 1; | WHERE employee_id = 1; | ||
| - | ===== UPDATE without Filter ===§== | + | ===== UPDATE without Filter ===== |
| If you omit the WHERE clause, the UPDATE command will modify every row in the table, which can lead to unintended changes, so it must be used with caution. | If you omit the WHERE clause, the UPDATE command will modify every row in the table, which can lead to unintended changes, so it must be used with caution. | ||
| Zeile 29: | Zeile 29: | ||
| **Example** | **Example** | ||
| UPDATE employees | UPDATE employees | ||
| - | SET salary = 70000; | + | SET salary = 70000; |
| - | + | ||
| - | + | ||
| - | + | ||
| ==== Vocabulary ==== | ==== Vocabulary ==== | ||