20 lines
587 B
SQL
20 lines
587 B
SQL
INSERT INTO kunde VALUES
|
|
(1, 'Ingmar', 'ingmar@example.com', 'FN239v_d32%nsej3'),
|
|
(3, 'Maria', 'maria@example.com', 'abc_%&'),
|
|
(4, 'John', 'john@example.com', 'KeepCalm'),
|
|
(2, 'Peter', 'peter@example.com', 'lskdfjlskdfj');
|
|
INSERT INTO produkt VALUES
|
|
(1, 'Keyboard', 'QUERTZ', 12, 29.99),
|
|
(2, 'Notebook', 'Standard', 1, 1299.00),
|
|
(3, 'Monitor', 'Flat', 5, 389.90),
|
|
(4, 'Maus', 'Kabellos', 2, 19.00);
|
|
INSERT INTO bestellung VALUES
|
|
(1, 1, '2022-01-03'),
|
|
(2, 1, '2022-01-07'),
|
|
(3, 2, '2022-01-09');
|
|
INSERT INTO bestellung_produkt VALUES
|
|
(1, 1, 2),
|
|
(1, 2, 1),
|
|
(2, 3, 4),
|
|
(3, 2, 2),
|
|
(3, 4, 1); |