AKSA-EFI/Geschwindigkeitsmessungen

Wiki-Quelltext dieser Seite.

<language>SQL</language>
= Spielwiese: Geschwindigkeitsmessungen = 


<code id="4d559531aca67" id="" id="" hidden>
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);

</code>

== Alle Einträge der Tabelle messungen anzeigen ==
<run id="4d559531acaf0" id="" id="">
SELECT * 
FROM messungen;
</run>