https://wiki.bzz.ch/ 2026-04-07T17:37:11+00:00 https://wiki.bzz.ch/ https://wiki.bzz.ch/_media/wiki/logo.png text/html 2024-10-17T10:46:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/modul/m290/learningunits/lu07/theorie/01?rev=1729161965&do=diff LU08a - SQL-DML: Basics Learning Objectives * Understand and Apply Data Insertion Concepts * Master the Use of UPDATE Statements with Filters * Safely Delete Records Using SQL DELETE Statements: * Demonstrate Practical Usage of SQL DML in Real-world Scenarios text/html 2024-10-25T13:30:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/modul/m290/learningunits/lu07/theorie/02?rev=1729863053&do=diff LU08b - SQL-DML: INSERT INTO Sources * W3Schools | INSERT INTO * MySQL.COM | INSERT INTO * INSERT Statement The INSERT command is used to add new records to a table. When using INSERT, it is essential to specify the table and columns where the data will be added. Syntax INSERT INTO table_name (column1, column2, column3) VALUES (value1, value2, value3); text/html 2024-10-17T10:45:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/modul/m290/learningunits/lu07/theorie/03?rev=1729161942&do=diff LU08c - SQL-DML: UPATE Sources: * W3Schools | UPDATE TABLE * MySQL.COM | UPDATE TABLE * Youtube | How to UPDATE and DELETE data from a TABLE 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. UPDATE with Filter (WHERE Clause) text/html 2024-10-17T11:49:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/modul/m290/learningunits/lu07/theorie/04?rev=1729165751&do=diff LU08d - SQL-DML: DELETE Sources: * 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)