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 12:54] – vdemir | modul:m290:learningunits:lu07:theorie:03 [2024/10/17 12:45] (aktuell) – vdemir | ||
|---|---|---|---|
| Zeile 1: | Zeile 1: | ||
| - | ====== | + | ====== |
| ** Sources:** | ** Sources:** | ||
| - [[https:// | - [[https:// | ||
| - | - [[http://example.com| Youtube | UPDATE TABLE ]] | + | - [[https://dev.mysql.com/ |
| + | - [[https:// | ||
| The UPDATE command is used to modify existing data in a table. It can be executed with or without a WHERE clause, depending on whether you want to update specific rows or all rows. | The UPDATE command is used to modify existing data in a table. It can be executed with or without a WHERE clause, depending on whether you want to update specific rows or all rows. | ||
| Zeile 19: | 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 28: | Zeile 29: | ||
| **Example** | **Example** | ||
| UPDATE employees | UPDATE employees | ||
| - | SET salary = 70000; | + | SET salary = 70000; |
| - | + | ||
| - | + | ||
| - | + | ||
| ==== Vocabulary ==== | ==== Vocabulary ==== | ||
| ^English ^ Deutsch ^ | ^English ^ Deutsch ^ | ||
| - | | Obsolete | + | | ...| ... | |
| - | | result-set | Ergebnismenge | | + | |
| ---- | ---- | ||
| [[https:// | [[https:// | ||