Romy

Aus ProgrammingWiki

Archivierte Version vom 2012-06-26T07:52:12+00:00. Aktuelle Version

Hier entsteht meine Datenbank zur Astronomie.

DROP TABLE IF EXISTS planet;
CREATE TABLE Planet (
  Position im Sonnensystem varchar(255),
  Name varchar(255),
  Masse varchar(255),
  Dichte varchar(30),
  Aggregatzustand varchar(255),
  Entfernung zur Sonne varchar(255),
  Monde varchar(255)
); 


INSERT INTO planet VALUES ('001', 'Merkur', '3,302x1023kg', '5,515g/cm³', 'fest', '58 Mio km', '0' );
INSERT INTO planet VALUES ('002', 'Venus', '4,869x1024kg', '5,243g/cm³', 'fest', '0', '108 Mio km');
INSERT INTO planet VALUES ('003', 'Erde', '5,97x1024kg', '5,15g/cm³', 'fest', '1', '148,6 Mio km');
INSERT INTO planet VALUES ('004', 'Mars', '6,419 x 1023 kg', '3,933 g/cm3', 'fest', '2', '228 Mio km');
INSERT INTO planet VALUES ('005', 'Jupiter', '1,899 x 1027 kg', '1,326 g/cm3', 'gasförmig', '63', '788 Mio km');
INSERT INTO planet VALUES ('006', 'Saturn', '5,685 x 1026 kg', '0,687 g/cm3', 'gasförmig', '60', '1500 Mio km');
INSERT INTO planet VALUES ('007', 'Uranus', '8,683 x 1025 kg', '1,27 g/cm3', 'gasförmig', '27', '3000 Mio km');
INSERT INTO planet VALUES ('008', 'Neptun', '1,0243x 1026 kg', '1,638g/cm3', 'gasförmig', '13', '4500 Mio km');

Romy

Suche