Re: How to allow incremental versions of the data in a DB

[Aftab Khan]

Alternatively, you can store none key attributes as XML, its easy to extend and manage.
for example:
-- Import XML Data Using the LOAD XML
http://dev.mysql.com/doc/refman/5.5/en/load-xml.html

-- Export Data as XML Using the --xml Option

shell> mysql --xml -e 'SELECT * FROM mytable' > file.xml

Use XML functions:

ExtractValue()
UpdateXML()

ExtractValue() that can be helpful to read required elements from xml; instead of returning entire xml back to the client application we can return one (or more) xml elements containing required data.

http://mysqlopt.blogspot.co.uk/

http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html



Edited 2 time(s). Last edit at 07/07/2012 11:05AM by Aftab Khan.