Many years ago, I wrote about importing XML data into MySQL using
ExtractValue()
. The reason I'm revisiting the
subject now is that I recently received an email request in
relation to my old blog post: I came across one of your blogs on
importing XML data to MySQL using ExtractData() and I am trying
to do the same using MySQL (5.5) database. However, I am new to
this kind of method and would like to seek your expertise on
this. I have an XML file that looks like this:
<?xml version="1.0" encoding="UTF-8"?>[Read more]
<wovoml xmlns="http://www.wovodat.org"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
version="1.1.0" xsi:schemaLocation="http://www.wovodat.org phread2.xsd">
<Data>
<Seismic>
<SingleStationEventDataset>
<SingleStationEvent code="VTAG_20160405000000" …