Hier werden die Unterschiede zwischen zwei Versionen gezeigt.
computer:tutorials:sql:tb-fill-loesung [2013/05/13 21:49] christian angelegt |
computer:tutorials:sql:tb-fill-loesung [2013/05/14 08:14] (aktuell) christian Hausnummer hinzugefügt |
||
---|---|---|---|
Zeile 1: | Zeile 1: | ||
======Kunden====== | ======Kunden====== | ||
<code> | <code> | ||
- | INSERT INTO kunden(K_Vorname,K_Nachname,K_Geburtstag,K_Strasse,K_Ort,K_Telefon,K_Email) VALUES ("Max","Mustermann","1990-07-09","Musterstraße 126",1,"0815/24985409","max@mustermann.de"); | + | INSERT INTO kunden(K_Vorname,K_Nachname,K_Geburtstag,K_Strasse,K_HausNr,K_Ort,K_Telefon,K_Email) VALUES ("Max","Mustermann","1990-07-09","Musterstraße","126",1,"0815/24985409","max@mustermann.de"); |
- | INSERT INTO kunden(K_Vorname,K_Nachname,K_Geburtstag,K_Strasse,K_Ort,K_Telefon,K_Email) VALUES ("Benjamin","Beispiel","1974-11-16","Beispielgasse 13",2,"0785/4355690","benjamin@beispielbu.rg"); | + | INSERT INTO kunden(K_Vorname,K_Nachname,K_Geburtstag,K_Strasse,K_HausNr,K_Ort,K_Telefon,K_Email) VALUES ("Benjamin","Beispiel","1974-11-16","Beispielgasse","13",2,"0785/4355690","benjamin@beispielbu.rg"); |
- | INSERT INTO kunden(K_Vorname,K_Nachname,K_Geburtstag,K_Strasse,K_Ort,K_Telefon,K_Email) VALUES ("Emil","Exempel","1954-06-26","Exampleroad 57",3,"06745/5898434","x-emil-x@exm.pl"); | + | INSERT INTO kunden(K_Vorname,K_Nachname,K_Geburtstag,K_Strasse,K_HausNr,K_Ort,K_Telefon,K_Email) VALUES ("Emil","Exempel","1954-06-26","Exampleroad","57",3,"06745/5898434","x-emil-x@exm.pl"); |
INSERT INTO orte(Ort, PLZ) VALUES ("Musterstadt", "00815"); | INSERT INTO orte(Ort, PLZ) VALUES ("Musterstadt", "00815"); |