Showing entries 1 to 2
Displaying posts with tag: xpath (reset)
Loading Arbitary XML documents into MySQL tables with p_load_xml

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"?>
 <wovoml xmlns=""
 version="1.1.0" xsi:schemaLocation=" phread2.xsd">
  <SingleStationEvent code="VTAG_20160405000000" owner1="169" …
[Read more]
Hidden Features Of Perl, PHP, Javascript, C, C++, C#, Java, Ruby, Python, And Others [Collection Of Incredibly Useful Lists]


StackOverflow is an amazing site for coding questions. It was created by Joel Spolsky of, Jeff Atwood of, and some other incredibly smart guys who truly care about user experience. I have been a total fan of SO since it went mainstream and it's now a borderline addiction (you can see my StackOverflow badge on the right sidebar).

The Story

Update 6/21/09: This server is currently under very heavy load (10-200), even with caching plugins enabled. Please bear with me as I try to resolve the situation.

Feel free to …

[Read more]
Showing entries 1 to 2