Advertisement
Guest User

Untitled

a guest
Dec 12th, 2016
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.13 KB | None | 0 0
  1. DROP TABLE IF EXISTS ueb_sel_ord;
  2. CREATE TABLE ueb_sel_ord
  3. (
  4. id int,
  5. username varchar(255),
  6. punkte int
  7. );
  8. INSERT INTO ueb_sel_ord (id,username,punkte) VALUES (1,'liesel34',2314);
  9. INSERT INTO ueb_sel_ord (id,username,punkte) VALUES (2,'michaelwesser',195);
  10. INSERT INTO ueb_sel_ord (id,username,punkte) VALUES (3,'ano85',8445);
  11. INSERT INTO ueb_sel_ord (id,username,punkte) VALUES (4,'Meerlis',5278);
  12. INSERT INTO ueb_sel_ord (id,username,punkte) VALUES (5,'joooschi',327);
  13. INSERT INTO ueb_sel_ord (id,username,punkte) VALUES (6,'Ginko5',12);
  14. INSERT INTO ueb_sel_ord (id,username,punkte) VALUES (7,'friedel',0);
  15. DROP TABLE IF EXISTS ueb_sel2;
  16. CREATE TABLE ueb_sel2
  17. (
  18. land varchar(255)
  19. );
  20. INSERT INTO ueb_sel2 (land) VALUES ('Deutschland');
  21. INSERT INTO ueb_sel2 (land) VALUES ('Frankreich');
  22. INSERT INTO ueb_sel2 (land) VALUES ('Polen');
  23. INSERT INTO ueb_sel2 (land) VALUES ('Österreich');
  24. INSERT INTO ueb_sel2 (land) VALUES ('Schweiz');
  25. INSERT INTO ueb_sel2 (land) VALUES ('Dänemark');
  26. INSERT INTO ueb_sel2 (land) VALUES ('Luxemburg');
  27. INSERT INTO ueb_sel2 (land) VALUES ('Italien');
  28. INSERT INTO ueb_sel2 (land) VALUES ('Deutschland');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement