Advertisement
Guest User

Untitled

a guest
Apr 26th, 2019
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. TABELLER SIDA 22:
  2. create table tblatomer
  3. (fldatomnummer integer,
  4. fldnamn varchar(30),
  5. fldavikt integer,
  6. fldkokpkt integer,
  7. fldfortkortn varchar(30),
  8. fldsmaltpkt integer,
  9. primary key (fldatomnummer));
  10.  
  11. // LÄGG TILL DATA
  12. insert into tblatomer
  13. (fldatomnummer, fldnamn, fldavikt, fldkokpkt, fldfortkortn, fldsmaltpkt)
  14. values
  15. (1, 'Väte','1','-252.8','H','-259.1'),
  16. (6, 'Kol','12','4200','C','630.5'),
  17. (7, 'Kväve','14','-195.8','N','-209.9'),
  18. (8, 'Syre','16','-183','O','-218.4'),
  19. (16, 'Svavel','32.1','444.6','S','113'),
  20. (17, 'Klor','35.5','-34.6','Cl','-103'),
  21. (28, 'Nickel','58.7','2900','Ni','1455'),
  22. (47, 'Silver','108','1950','Ag','960.5'),
  23. (51, 'Antimon','122','1380','Sb','630.5'),
  24. (53, 'Jod','127','184.4','I','113.5');
  25.  
  26. ÖVRIGA TABELLER SIDA 22:
  27. TBLELEVER
  28. create table tblelever
  29. (fldFnamn varchar(30),
  30. fldEnamn varchar(30),
  31. fldklass varchar(30),
  32. fldpstnr integer,
  33. fldandraspr varchar(30),
  34. fldelevnr integer,
  35. fldgatuadr varchar(30),
  36. fldpostadr varchar(30),
  37. primary key (fldelevnr));
  38.  
  39. TBLKOMMUN:
  40. create table tblkommun
  41. (fldkommun varchar(30),
  42. fldlän varchar(30),
  43. fldfolkmängd integer,
  44. fldyta integer,
  45. primary key (fldkommun));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement