Richard

Aus ProgrammingWiki

Archivierte Version vom 2012-07-03T07:52:49+00:00. Aktuelle Version

'Hier entsteht meine Astronomie Datenbank'

DROP TABLE Planeten IF EXISTS;
CREATE TABLE Planeten (
  NamePlanet varchar(255),
  Entfernung_zur_Sonne varchar(255),
  Laenge_Umlaufbahn varchar(255),
  Masse varchar(30),
  Atmosphaere varchar(255),
  Temperatur varchar(255),
  Dichte varchar(255)
); 


INSERT INTO Planeten VALUES ('Merkur', '0,39 AE', '87,969 d', '3,302 · 10^23 kg', 'Nein', '440 K', '5,427 g/cm³');
INSERT INTO Planeten VALUES ('Venus', '0,72 AE', '224,701 d', '4,869 · 10^24 kg', 'Ja', '737 K', '5,243 g/cm³');
INSERT INTO Planeten VALUES ('Erde', '1 AE', '365,256 d', '5,974 · 10^24 kg', 'Ja', '288 K', '5,515 g/cm³');
INSERT INTO Planeten VALUES ('Mars', '1,52 AE', '686,980 d', '6,419 · 10^23 kg', 'Ja(Dünn)', '218 K', '3,933 g/cm³');
INSERT INTO Planeten VALUES ('Juptier', '5,2 AE', '4328,9 d', '1,899 · 10^27 kg', 'Nein', '165 K', '1,326 g/cm³');
INSERT INTO Planeten VALUES ('Saturn', '9,53 AE', '10751,805 d', '5,685 · 10^26 kg', 'Nein', '134 K', '0,687 g/cm³');
INSERT INTO Planeten VALUES ('Uranus', '19,2 AE', '30664,015 d', '8,683 · 10^25 kg', 'Nein', '76 K', '1,27 g/cm³');
INSERT INTO Planeten VALUES ('Neptun', '30,1 AE', '60148,35 d', '1,0243 · 10^26 kg', 'Nein', '72 K', '1,638 g/cm³');

Richard

Suche