modul:m290:learningunits:lu06:aufgaben:a01

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:lu06:aufgaben:a01 [2024/10/29 11:49] – vdemirmodul:m290:learningunits:lu06:aufgaben:a01 [2024/10/29 11:55] (aktuell) – vdemir
Zeile 29: Zeile 29:
  
 ==== Task 1.4: ==== ==== Task 1.4: ====
-** Create a test table**: Create a table //user// with 3 columns of your choice as a test table.+** Create a test table**: Create a table //users// with 3 columns of your choice as a test table.
  
-  CREATE TABLE user (+  CREATE TABLE users (
     user_id INT AUTO_INCREMENT PRIMARY KEY,     user_id INT AUTO_INCREMENT PRIMARY KEY,
     username VARCHAR(50) NOT NULL,     username VARCHAR(50) NOT NULL,
Zeile 40: Zeile 40:
 **Content data for testing:** Fill the table user with some test data:  **Content data for testing:** Fill the table user with some test data: 
      
-  INSERT INTO user (username, email) VALUES ('john_doe', 'john.doe@example.com'); +  INSERT INTO users (username, email)  
-  INSERT INTO user (username, email) VALUES ('jane_smith', 'jane.smith@example.com'); +  VALUES  ('john_doe', 'john.doe@example.com'), 
-  INSERT INTO user (username, email) VALUES ('michael_brown', 'michael.brown@example.com'); +        ('jane_smith', 'jane.smith@example.com'), 
-  INSERT INTO user (username, email) VALUES ('sarah_johnson', 'sarah.johnson@example.com'); +        ('michael_brown', 'michael.brown@example.com'), 
-  INSERT INTO user (username, email) VALUES ('chris_williams', 'chris.williams@example.com'); +        ('sarah_johnson', 'sarah.johnson@example.com'), 
-  INSERT INTO user (username, email) VALUES ('anna_lee', 'anna.lee@example.com'); +        ('chris_williams', 'chris.williams@example.com'), 
-  INSERT INTO user (username, email) VALUES ('david_kim', 'david.kim@example.com'); +        ('anna_lee', 'anna.lee@example.com'), 
-  INSERT INTO user (username, email) VALUES ('laura_clark', 'laura.clark@example.com'); +        ('david_kim', 'david.kim@example.com'),  
-  INSERT INTO user (username, email) VALUES ('jake_lewis', 'jake.lewis@example.com'); +        ('laura_clark', 'laura.clark@example.com'),  
-  INSERT INTO user (username, email) VALUES ('emily_martinez', 'emily.martinez@example.com');+        ('jake_lewis', 'jake.lewis@example.com'), 
 +        ('emily_martinez', 'emily.martinez@example.com');
  
 ===== Solution ===== ===== Solution =====
  • modul/m290/learningunits/lu06/aufgaben/a01.1730198961.txt.gz
  • Zuletzt geändert: 2024/10/29 11:49
  • von vdemir