yY5RWktj

1#Aufgabe Tag 9 20190607
2
3SELECT * FROM name3000jason;
4
5DROP TABLE IF EXISTS name3000xml;
6CREATE table IF NOT EXISTS name3000xml (
7	`Full` varchar(60),
8	Country varchar(60),
9    `Created` varchar(100),
10    Id	int,
11	Email varchar(60)
12);
13
14/*
15ALTER TABLE `mietwerkzeugag`.`name3000xml` 
16CHANGE COLUMN `Full` `Full name` VARCHAR(60) NULL DEFAULT NULL ,
17CHANGE COLUMN `Created` `Created at` VARCHAR(100) NULL DEFAULT NULL ;
18*/
19
20
21LOAD XML
22INFILE "C:\\Users\\Alfa\\Desktop\\Name3000.xml"
23#REPLACE
24INTO TABLE mietwerkzeugag.name3000xml
25CHARACTER SET utf8
26ROWS IDENTIFIED BY '<record>'
27;
28
29
30
31
32select * from name3000jason;
33
34
35select COUNT(Email) from name3000xml;
36
37SELECT COUNT(Email) from name3000jason;
38
39#INNER JOIN ON Country LAENDER
40SELECT x.Full, j.IP FROM name3000xml as x
41LEFT JOIN name3000jason as j ON x.Email = j.Email
42;
43
44
45
46/* 
47Hex tests
48
49SELECT "Hallo Welt";
50
51
52SELECT UNHEX(HEX("FFFFFF"));
53
54SELECT UNHEX('4D7953514C');
55
56*/