Florian

Aus ProgrammingWiki

Archivierte Version vom 2019-01-11T06:45:33+00:00. Aktuelle Version

Hallo i bims 1 Datenbank

CREATE TABLE Place (Code INTEGER,Name VARCHAR(255));
CREATE INDEX iCode ON Place (Code);

CREATE TABLE Customer (Nr INTEGER,Name VARCHAR(255),Place INTEGER);
CREATE INDEX iNr ON Customer (Nr);

INSERT INTO Place VALUES (6900,'Lugano');
INSERT INTO Customer VALUES (1,'Meier',3000);

SELECT * FROM Customer;

Florian

Suche