AKSA-EFI/Geschwindigkeitsmessungen

Aus ProgrammingWiki
Wiki-Quelltext dieser Seite.
<language>SQL</language>
= Spielwiese: Geschwindigkeitsmessungen = 


<code id="4d559531aca67" id="" id="" hidden>
DROP TABLE IF EXISTS messungen ;
CREATE TABLE messungen (
  tempo INT NOT NULL,
  richtung VARCHAR(20),
  laenge VARCHAR(20),
  typ VARCHAR(20),
  stunde INT,
  busse BOOLEAN
);

INSERT INTO messungen VALUES (29, 1, 5100, 'Lieferwagen', 15, false);
INSERT INTO messungen VALUES (63, 1, 1100, 'Töff', 15, true);
INSERT INTO messungen VALUES (30, 1, 4800, 'PWK', 15, false);
INSERT INTO messungen VALUES (32, 1, 4900, 'PWK', 15, false);
INSERT INTO messungen VALUES (37, 1, 5000, 'Lieferwagen', 15, false);
INSERT INTO messungen VALUES (34, 1, 4700, 'PWK', 15, false);
INSERT INTO messungen VALUES (65, 1, 2600, 'Töff', 15, true);
INSERT INTO messungen VALUES (45, 1, 3500, 'PWK', 15, false);
INSERT INTO messungen VALUES (46, 1, 3700, 'PWK', 15, false);
INSERT INTO messungen VALUES (56, 2, 5500, 'Lieferwagen', 16, true);
INSERT INTO messungen VALUES (59, 2, 4800, 'PWK', 16, true);
INSERT INTO messungen VALUES (45, 2, 5500, 'Lieferwagen', 16, false);
INSERT INTO messungen VALUES (47, 2, 5500, 'Lieferwagen', 16, false);
INSERT INTO messungen VALUES (62, 2, 6500, 'Lieferwagen', 16, true);
INSERT INTO messungen VALUES (50, 2, 4600, 'PWK', 16, false);
INSERT INTO messungen VALUES (51, 2, 5200, 'Lieferwagen', 16, false);
INSERT INTO messungen VALUES (75, 2, 5800, 'Lieferwagen', 16, true);
INSERT INTO messungen VALUES (50, 2, 5500, 'Lieferwagen', 16, false);
INSERT INTO messungen VALUES (45, 2, 4500, 'PWK', 16, false);
INSERT INTO messungen VALUES (48, 2, 5900, 'Lieferwagen', 16, false);
INSERT INTO messungen VALUES (53, 1, 4100, 'PWK', 16, false);
INSERT INTO messungen VALUES (54, 1, 5100, 'Lieferwagen', 16, true);
INSERT INTO messungen VALUES (82, 1, 4800, 'PWK', 16, true);
INSERT INTO messungen VALUES (47, 2, 4400, 'PWK', 17, false);
INSERT INTO messungen VALUES (48, 2, 5200, 'Lieferwagen', 17, false);
INSERT INTO messungen VALUES (60, 2, 4200, 'PWK', 17, true);

</code>

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

Suche
