PMG/Profil nawi 10 1112/Richard

Aus ProgrammingWiki
Wiki-Quelltext dieser Seite.
<language>SQL</language>
''''''Hier entsteht meine Astronomie Datenbank''''''

<code id="4fcdb9c46ddb0">
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³');
</code>

<run id="4fcdb9c46de22">

</run>
PMG/Profil nawi 10 1112/Richard

Suche
