Hans

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');