PMG1719/DB Beleg/Florian

Wiki-Quelltext dieser Seite.

<language>SQL</language>
Hallo i bims 1 Datenbank

<code id="17">

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

</code>

<run id="17">

SELECT * FROM Customer;

</run>