AKSA-EFI/Tennis

Wiki-Quelltext dieser Seite.

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

<code id="4f5a5c566a18e" id="" id="" id="" hidden>

DROP TABLE IF EXISTS matches;

CREATE TABLE matches (
  id INTEGER NOT NULL, 
  tournier VARCHAR(35),
  gewinnsaetze INTEGER NOT NULL,
  jahr INTEGER NOT NULL,
  sieger VARCHAR(35),
  gegner VARCHAR(35),
  runde VARCHAR(35),
  dauer INTEGER,
  gespielte_saetze INTEGER,
  PRIMARY KEY (id)
);

INSERT INTO matches VALUES (1, 'Dubai Tennis', 2, 2012, 'Federer', 'Murray', 'Final', null, 2);
INSERT INTO matches VALUES (2, 'Dubai Tennis', 2, 2012, 'Federer', 'Del Potro', 'Halbfinal', null, 2);
INSERT INTO matches VALUES (3, 'Dubai Tennis', 2, 2012, 'Murray', 'Djokovic', 'Halbfinal', null, 2);

INSERT INTO matches VALUES (4, 'Australian Open', 3, 2012, 'Djokovic', 'Nadal', 'Final', 80+66+45+88+74, 2);
INSERT INTO matches VALUES (5, 'Australian Open', 3, 2012, 'Djokovic', 'Murray', 'Halbfinal', 47+65+88+25+65, 5);
INSERT INTO matches VALUES (6, 'Australian Open', 3, 2012, 'Nadal', 'Federer', 'Halbfinal', 56+44+67+55, 3);

INSERT INTO matches VALUES (7, 'US Open', 3, 2011, 'Djokovic', 'Nadal', 'Final', 53+71+84+42, 4);
INSERT INTO matches VALUES (8, 'US Open', 3, 2011, 'Djokovic', 'Federer', 'Halbfinal', 55+46+42+33+55, 5);
INSERT INTO matches VALUES (9, 'US Open', 3, 2011, 'Nadal', 'Murray', 'Halbfinal', 55+49+49+51, 4);

INSERT INTO matches VALUES (10, 'Wimbledon', 3, 2011, 'Djokovic', 'Nadal', 'Final', 41+33+30+44, 4);
INSERT INTO matches VALUES (11, 'Wimbledon', 3, 2011, 'Nadal', 'Murray', 'Halbfinal', 54+36+36+53, 4);
INSERT INTO matches VALUES (12, 'Wimbledon', 3, 2011, 'Djokovic', 'Tsonga', 'Halbfinal', 65+28+59+35, 4);

INSERT INTO matches VALUES (13, 'French Open', 3, 2011, 'Nadal', 'Federer', 'Final', 62+72+50+36, 4);
INSERT INTO matches VALUES (14, 'French Open', 3, 2011, 'Nadal', 'Murray', 'Halbfinal', 62+73+62, 3);
INSERT INTO matches VALUES (15, 'French Open', 3, 2011, 'Federer', 'Djokovic', 'Halbfinal', 70+45+37+67, 4);

INSERT INTO matches VALUES (16, 'Australian Open', 3, 2011, 'Djokovic', 'Murray', 'Final', null, 3);
INSERT INTO matches VALUES (17, 'Australian Open', 3, 2011, 'Djokovic', 'Federer', 'Halbfinal', null, 3);
INSERT INTO matches VALUES (18, 'Australian Open', 3, 2011, 'Murray', 'Ferrer', 'Halbfinal', null, 4);

</code>

== Alle Einträge anzeigen ==
<run id="4f5a5c566a396" id="" id="" id="">
SELECT * FROM matches;
</run>