modul:m290:learningunits:lu07:theorie:02

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen Revision Vorhergehende Überarbeitung
Nächste Überarbeitung		 Vorhergehende Überarbeitung
modul:m290:learningunits:lu07:theorie:02 [2024/09/30 13:20] – vdemirmodul:m290:learningunits:lu07:theorie:02 [2024/10/25 15:30] (aktuell) – vdemir
Zeile 1: Zeile 1:
-====== LU07b - SQL-DML: INSERT INTO ======+====== LU08b - SQL-DML: INSERT INTO ======
  
 **Sources**  **Sources** 
   - [[https://www.w3schools.com/sql/sql_insert.asp | W3Schools | INSERT INTO ]]   - [[https://www.w3schools.com/sql/sql_insert.asp | W3Schools | INSERT INTO ]]
   - [[https://dev.mysql.com/doc/refman/8.4/en/insert.html | MySQL.COM | INSERT INTO]]   - [[https://dev.mysql.com/doc/refman/8.4/en/insert.html | MySQL.COM | INSERT INTO]]
-  - [[https://www.youtube.com/watch?v=Cxilfg-M158 | Youtube | How to INSERT rows into a TABLE]]+  - {{ :modul:m290:learningunits:lu07:theorie:mysql_how_to_insert_rows_into_a_table.mp4 |}} 
  
 ===== INSERT Statement ===== ===== INSERT Statement =====
Zeile 16: Zeile 17:
   INSERT INTO employees (employee_id, first_name, last_name, hire_date, salary)    INSERT INTO employees (employee_id, first_name, last_name, hire_date, salary) 
   VALUES (1, 'John', 'Doe', '2023-09-18', 55000);   VALUES (1, 'John', 'Doe', '2023-09-18', 55000);
 +  
 +
  
-===== SINGLE or MULTIPLE INSERTS =====+===== SINGLE VS MULTIPLE INSERTS =====
 In SQL, inserting data into tables is a fundamental operation that is often performed using the INSERT INTO statement. This statement allows you to add new rows to a database table, either one at a time or in bulk. The two primary ways to insert data are through **single inserts** and **multiple inserts**. In SQL, inserting data into tables is a fundamental operation that is often performed using the INSERT INTO statement. This statement allows you to add new rows to a database table, either one at a time or in bulk. The two primary ways to insert data are through **single inserts** and **multiple inserts**.
  
Zeile 37: Zeile 40:
                    
 Multiple inserts are useful when you need to insert a large set of data at once, as it can significantly improve performance compared to running multiple single insert statements. Multiple inserts are useful when you need to insert a large set of data at once, as it can significantly improve performance compared to running multiple single insert statements.
 +
 +
  
 ==== Conclusion ==== ==== Conclusion ====
  • modul/m290/learningunits/lu07/theorie/02.1727695240.txt.gz
  • Zuletzt geändert: 2024/09/30 13:20
  • von vdemir