Re: LOAD XML LOCAL INFILE having problems with XML with multiple column types.

[Skyler Truax]

What errors are you getting the same?

The documentation shows this example:

<list>
<person person_id="1" fname="Kapek" lname="Sainnouine"/>
<person person_id="2" fname="Sajon" lname="Rondela"/>
<person person_id="3"><fname>Likame</fname><lname>Örrtmons</lname></person>
<person person_id="4"><fname>Slar</fname><lname>Manlanth</lname></person>
<person><field name="person_id">5</field><field name="fname">Stoma</field>
<field name="lname">Milu</field></person>
<person><field name="person_id">6</field><field name="fname">Nirtam</field>
<field name="lname">Sklöd</field></person>
<person person_id="7"><fname>Sungam</fname><lname>Dulbåd</lname></person>
<person person_id="8" fname="Sraref" lname="Encmelt"/>
</list>

And states the Load XML should understand it.



The example here is somewhat like my screwed up data format:

<person person_id="7"><fname>Sungam</fname><lname>Dulbåd</lname></person>


Except mine is missing some closing tags.

I wonder if I add closing tags if it will work.

Wont help me process the million records I need to, but it will at least let me know what wont work.