MySQL’s new XML Functions
XML or Extensible Markup Language is an increasingly popular method of storing general information. To date its most widely used purpose has been feeds for various websites; but XML is much more than just an easy way to get the latest from your favourite blogs and news websites. MySQL has now introduced XML Functions allowing seamless integration of XML within a database.
A key part of this is XPath, a language specifically designed for reading information in an XML document. XPath can be used to navigate through elements and attributes in an XML document. XPath is used in conjunction with two MySQL functions which find and replace/return the data from the database.
- ExtractValue() uses two attributes to find and return specific information within an XML document in your MySQL Database.
- UpdateXML() uses three attributes to find and replace data within the XML document on the database.
I’ll be adding a post about SimpleXML for PHP which forgoes the need for a database all together.
Related Posts
Post Information
Written on 1 October 2009 at 5.51 pm, by Keith Greer. "MySQL’s new XML Functions" was posted in MySQL with the tags data, MySQL, XML . Comments Off
Social Networks: Facebook, Twitter, Google Bookmarks, del.icio.us, StumbleUpon, Digg, Reddit, Posterous.
