Aus ProgrammingWiki

Spielwiese: Geschwindigkeitsmessungen

CREATE TABLE messungen ( tempo INT NOT NULL, richtung INT NOT NULL, laenge INT NOT NULL, typ VARCHAR(20), stunde INT, busse INT ); INSERT INTO messungen VALUES (29, 1, 5100, 'Lieferwagen', 15, 0); INSERT INTO messungen VALUES (63, 1, 1100, 'Töff', 15, 1); INSERT INTO messungen VALUES (30, 1, 4800, 'PKW', 15, 0); INSERT INTO messungen VALUES (32, 1, 4900, 'PKW', 15, 0); INSERT INTO messungen VALUES (37, 1, 5000, 'Lieferwagen', 15, 0); INSERT INTO messungen VALUES (34, 1, 4700, 'PKW', 15, 0); INSERT INTO messungen VALUES (65, 1, 2600, 'Töff', 15, 1); INSERT INTO messungen VALUES (45, 1, 3500, 'PKW', 15, 0); INSERT INTO messungen VALUES (46, 1, 3700, 'PKW', 15, 0); INSERT INTO messungen VALUES (56, 2, 5500, 'Lieferwagen', 16, 1); INSERT INTO messungen VALUES (59, 2, 4800, 'PKW', 16, 1); INSERT INTO messungen VALUES (45, 2, 5500, 'Lieferwagen', 16, 0); INSERT INTO messungen VALUES (47, 2, 5500, 'Lieferwagen', 16, 0); INSERT INTO messungen VALUES (62, 2, 6500, 'Lieferwagen', 16, 1); INSERT INTO messungen VALUES (50, 2, 4600, 'PKW', 16, 0); INSERT INTO messungen VALUES (51, 2, 5200, 'Lieferwagen', 16, 0); INSERT INTO messungen VALUES (75, 2, 5800, 'Lieferwagen', 16, 1); INSERT INTO messungen VALUES (50, 2, 5500, 'Lieferwagen', 16, 0); INSERT INTO messungen VALUES (45, 2, 4500, 'PKW', 16, 0); INSERT INTO messungen VALUES (48, 2, 5900, 'Lieferwagen', 16, 0); INSERT INTO messungen VALUES (53, 1, 4100, 'PKW', 16, 0); INSERT INTO messungen VALUES (54, 1, 5100, 'Lieferwagen', 16, 1); INSERT INTO messungen VALUES (82, 1, 4800, 'PKW', 16, 1); INSERT INTO messungen VALUES (47, 2, 4400, 'PKW', 17, 0); INSERT INTO messungen VALUES (48, 2, 5200, 'Lieferwagen', 17, 0); INSERT INTO messungen VALUES (60, 2, 4200, 'PKW', 17, 1);

Alle Einträge der Tabelle messungen anzeigen

SELECT * FROM messungen;

ausführen