In this article, we discuss the XML functionality available in MySQL, with an emphasis on new features coming online in MySQL 5.1 and MySQL 6.0. We assume that you already have a working knowledge of XML, and that you know what the terms “valid” and “well-formed” mean. We also assume that you have some knowledge of XPath.

We cover the following topics:

• Methods for outputting MySQL data in XML format, including the use of lib_mysqludf_xql, a third-party library that can be used for this task

• Using the functions (new in MySQL 5.1) ExtractValue() and UpdateXML() for working with XML and XPath

• Storing data from XML in a MySQL database using the LOAD XML statement (implemented in MySQL 6.0)

• Some security considerations to keep in mind when using these techniques

Full Article

Source : dev.mysql.com

1. MySQL Stored Procedures: CASE syntax
2. MySQL 5.1 data dictionary diagram
3. MySQL 5.1 partitions in practice
4. A Primer on Falcon Tablespaces
5. MySQL Sandbox University lesson - June 12, 14:00 GMT
6. COUNT(*) vs COUNT(col)
7. High Performance MySQL 2nd Edition is in production
8. The top 20 design tips for MySQL Enterprise data architects
9. InnoDB Sessions at MySQL Conference
10. Database Security Talk
11. Webinar - Reduce the TCO with MySQL
12. Reading the guide
13. How to create a MySQL Database
14. Designing Scalable Architectures with MySQL Proxy
15. MySQL Conference Tracks for the DBA
16. Top 20 DB Design Tips Every Architect Needs to Know part 5
17. Top 20 DB Design Tips Every Architect Needs to Know
18. MySQL Special Promotions - Training Services
19. High Performance MySQL Second Edition Schedule
20. Top 20 DB Design Tips Every Architect Needs to Know part 3
21. Interview by Sun TV at MySQL Conference
22. Top 20 DB Design Tips Every Architect Needs to Know part 4
23. An Introduction to BLOB Streaming for MySQL part 4
24. Top 20 DB Design Tips Every Architect Needs to Know part 2
25. An Introduction to BLOB Streaming for MySQL part 2
26. An Introduction to BLOB Streaming for MySQL part 3
27. Two second editions, two first times
28. An Introduction to BLOB Streaming for MySQL part 5
29. MySQL Obfuscator, What features do you want to see
30. An Introduction to BLOB Streaming for MySQL
31. Drizzling MySQL
32. Employee MySQL virtual columns
33. Capacity Planning, Archetecture, Scaling, Response time, Throughput
34. OSCON 2008 - MySQL Proxy - from architecture to implementation
35. Wonderful world of MySQL Storage Engines
36. MySQL Proxy @ OSCON 08
37. MySQL University Thu 30 Oct
38. UC2009 - A few days, a few wishes