Romy

Aus ProgrammingWiki

Archivierte Version vom 2012-06-26T07:46:27+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³', '0', 'fest', '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 · 1023 kg', '3,933 g/cm3', 'fest', '2', '228 Mio km');
INSERT INTO planet VALUES ('005', 'Jupiter', '1,899 · 1027 kg', '1,326 g/cm3', 'gasförmig', '63', '788 Mio km');
INSERT INTO planet VALUES('006', 'Saturn', '5,685 · 1026 kg', '0,687 g/cm3', 'gasförmig', '60', '1500 Mio km');
INSERT INTO planet VALUES
('007', 'Uranus', '8,683 · 1025 kg', '1,27 g/cm3', 'gasförmig', '27', '3000 Mio km');
INSERT INTO planet VALUES
('008', 'Neptun', '1,0243· 1026 kg', '1,638g/cm3', 'gasförmig', '13', '4500 Mio km');

Romy

Suche