PMG/Profil nawi 10 1112/Hans

Wiki-Quelltext dieser Seite.

<language>SQL</language>
Hier entsteht meine Datenbank zur Astronomie.

DROP TABLE IF EXISTS Planeten;
CREATE TABLE Planeten (
  P_NR varchar(255),
  Name varchar(255),
  Masse varchar(255),
  Dichte varchar(30),
  Temperatur varchar(255),
  Atmosphäre varchar(255),
  Größe varchar(255)); 
  

INSERT INTO Planeten VALUES ('01', 'Merkur', '5,427 g/cm3', '5,427 g/cm3', '-173°C - 427°C', 'nein', '0,39 AE');
INSERT INTO Planeten VALUES ('02', 'Venus', '5,243 g/cm3', '5,243 g/cm3', '437°C - 497°C', 'ja', '0,729 AE');
INSERT INTO Planeten VALUES ('03', 'Erde', '5,515 g/cm3', '5,515 g/cm3', '-89°C - 58°C', 'ja', '1 AE');
INSERT INTO Planeten VALUES ('04', 'Mars', '3,933 g/cm3', '3,933 g/cm3', '-133°C - 27°C', 'ja', '1,523 AE');
INSERT INTO Planeten VALUES ('05', 'Jupiter', '1,326 g/cm3', '1,326 g/cm3', '108 °C', 'nein', '5,2 AE');
INSERT INTO Planeten VALUES ('06', 'Saturn', '0,687 g/cm3', '0,687 g/cm3', '-150°C - -200°C', 'nein', '9,6 AE');
INSERT INTO Planeten VALUES ('07', 'Uranus', '1,27 g/cm3', '1,27 g/cm3', '- 215°C', 'nein', '19,2 AE');
INSERT INTO Planeten VALUES ('08', 'Neptun', '1,638 g/cm3', '1,638 g/cm3', '- 201°C', 'nein', '30 AE');