Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- computer:tutorials:sql:tb-fill-loesung [2013/05/13 21:49] – angelegt christian
+++ computer:tutorials:sql:tb-fill-loesung [2013/05/14 08:14] (aktuell) – Hausnummer hinzugefügt christian
@@ Zeile 1: / Zeile 1: @@
 ======Kunden======
 <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");