· 6 years ago · Jun 07, 2019, 01:04 PM
1DROP TABLE IF EXISTS name3000xml;
2CREATE table IF NOT EXISTS name3000xml (
3 `Full` varchar(60),
4 Country varchar(60),
5 `Created` varchar(100),
6 Id int,
7 Email varchar(60)
8);
9
10
11
12
13LOAD XML
14INFILE "C:\\Users\\Alfa\\Desktop\\Name3000.xml"
15#REPLACE
16INTO TABLE mietwerkzeugag.name3000xml
17CHARACTER SET utf8
18ROWS IDENTIFIED BY '<record>'
19
20;