Beide Seiten der vorigen Revision Vorhergehende Überarbeitung | |
modul:m290:learningunits:lu06:aufgaben:a01 [2024/10/29 11:51] – [Task 1.5:] vdemir | modul:m290:learningunits:lu06:aufgaben:a01 [2024/10/29 11:55] (aktuell) – vdemir |
---|
**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 users (username, email) VALUES ('john_doe', 'john.doe@example.com'); | INSERT INTO users (username, email) |
INSERT INTO users (username, email) VALUES ('jane_smith', 'jane.smith@example.com'); | VALUES ('john_doe', 'john.doe@example.com'), |
INSERT INTO users (username, email) VALUES ('michael_brown', 'michael.brown@example.com'); | ('jane_smith', 'jane.smith@example.com'), |
INSERT INTO users (username, email) VALUES ('sarah_johnson', 'sarah.johnson@example.com'); | ('michael_brown', 'michael.brown@example.com'), |
INSERT INTO users (username, email) VALUES ('chris_williams', 'chris.williams@example.com'); | ('sarah_johnson', 'sarah.johnson@example.com'), |
INSERT INTO users (username, email) VALUES ('anna_lee', 'anna.lee@example.com'); | ('chris_williams', 'chris.williams@example.com'), |
INSERT INTO users (username, email) VALUES ('david_kim', 'david.kim@example.com'); | ('anna_lee', 'anna.lee@example.com'), |
INSERT INTO users (username, email) VALUES ('laura_clark', 'laura.clark@example.com'); | ('david_kim', 'david.kim@example.com'), |
INSERT INTO users (username, email) VALUES ('jake_lewis', 'jake.lewis@example.com'); | ('laura_clark', 'laura.clark@example.com'), |
INSERT INTO users (username, email) VALUES ('emily_martinez', 'emily.martinez@example.com'); | ('jake_lewis', 'jake.lewis@example.com'), |
| ('emily_martinez', 'emily.martinez@example.com'); |
| |
===== Solution ===== | ===== Solution ===== |