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

[Peter Brawley]

This ...

  <App action="A" id="3253494">
    <BaseVehicle id="130131" />
    <EngineBase id="5472" />
    <Aspiration id="5" />
    <Qty />
    <PartType id="999999">Tube nut</PartType>
    <Part />
    <AssetName>3910045</AssetName>
    <AssetItemRef>19</AssetItemRef>
  </App>

... specifies rows for one table? Can we see the Show Create Table result for that table? And remember, before 5.7.9 empty values were handled incorrectly.