DROP TABLE IF EXISTS

CREATE TABLE (name VARCHAR(30), vorname VARCHAR(25), personalnummer INT(11), gehalt DOUBLE, geburtstag DATE, PRIMARY KEY personalnummer (personalnummer) )

INSERT INTO VALUES ('Maier', 'Hans', 6714, '3500', '1962-03-15');
INSERT INTO VALUES ('Schmitz', 'Peter', 81343, '3750', '1958-04-12');
INSERT INTO VALUES ('Mertens', 'Julia', 2297, '3621.5', '1959-12-30');