Sie sind hier: MySQL
Zurück zu: DBS
Allgemein:
Vorlesungen
Labore
Sinnvolle Programme
Lineare Regression
GUI-Entwurfsarbeit
Single-Format
Design Pattern-Termine
Observer1
Bsp2
Json-Array
Json-Dialogelemente
Webtechnologien
CREATE TABLE `EMPLOYEE` ( `PINDEX` INTEGER NOT NULL AUTO_INCREMENT, `CNR` INTEGER DEFAULT 0 NOT NULL UNIQUE, `LASTNAME` VARCHAR(50) DEFAULT '', `FIRSTNAME` VARCHAR(50) DEFAULT '', `STREET` VARCHAR(50) DEFAULT '', `BIRTHDAY` VARCHAR(10) DEFAULT '2018-01-01', CONSTRAINT `PK_EMPLOYEE` PRIMARY KEY (`PINDEX`) ); Insert into employee( cnr, lastname, firstname, street, birthday) Values( 12345, 'Meier', 'Hans', 'Friedrichstrasse 55', '2018-03-14'); Insert into employee(cnr, lastname, firstname, street, birthday) Values( 54321,'Schulze', 'Susanne', 'Langgasse 4a', '2011-03-07'); Insert into employee(cnr, lastname, firstname, street, birthday) Values(234, 'Brandter', 'Torsten', 'Marktstrasse 5', '2018-03-07'); Insert into employee(cnr, lastname, firstname, street, birthday) Values(42, 'Dent', 'Arthur', 'Magarethea Weg 12', '1996-08-07'); Insert into employee(cnr, lastname, firstname, street, birthday) Values(142, 'Braun', 'Werner', 'Nasa 1969', '1969-07-20'); Insert into employee(cnr, lastname, firstname, street, birthday) Values(145, 'Brandt', 'Willi', 'Kastanieallee 12a', '1971-02-10'); Insert into employee( cnr, lastname, firstname, street, birthday) Values(345, 'Schmitt', 'Dorethea', 'Martkstrasse 3', '2001-12-24'); Insert into employee(cnr, lastname, firstname, street, birthday) Values(11, 'Schwarzenau', 'Paul', 'Kreuzerweg 12a', '2001-04-17'); Insert into employee(cnr, lastname, firstname, street, birthday) Values(55, 'Gisin', 'Nicola', 'Springerallee 1', '1999-12-24'); Insert into employee(cnr, lastname, firstname, street, birthday) Values(123, 'Genius', 'Chantal', 'Hallenser Strasse 3', '1991-02-10'); Insert into employee( cnr, lastname, firstname, street, birthday) Values(77, 'Schoen', 'Jaqueline', 'Einkaufsallee 123', '1991-02-11'); Insert into employee(cnr, lastname, firstname, street, birthday) Values(14, 'Schwarz', 'Hans-Georg', 'Lange Strasse 3', '1985-06-27'); Insert into employee(cnr, lastname, firstname, street, birthday) Values(35, 'Maurer', 'Fritz', 'Handwerkerweg 5', '1979-02-29'); Insert into employee(cnr, lastname, firstname, street, birthday) Values(113, 'Bosch', 'Hieronymus', 'Kunstweg 42', '1998-05-11'); Insert into employee( cnr, lastname, firstname, street, birthday) Values(57, 'Brandtner', 'Andrea', 'Rosenweg 2', '2001-02-03');