MySQL Forums
Forum List  »  Views

MySQL XML stored in View ?
Posted by: vic santoro
Date: October 03, 2013 06:40AM

I currently work in oracle but I am building a new application using MySQL.
In oracle I create xml by using xmlelement,xmlattributes, xmlagg, xmlforest..etc..
Then I create a view from the xml and my apps will pull all the xml from the view.

Can I do anything similiar to this with MySQL ?
I know I can create the xml with PHP which is what I have done. But I want to be able to create all the xml in the database and store in a view. This way the DB Developers have full access to the sql and the web developers do not have to deal with sql.

I have scoured the internet but cannot really find anything built into MySQL that lets me generate xml and store in a view.
Thank you.

PS - I forgot to mention the MySQL I am using is on a Shared Hosting Platform.

Edited 1 time(s). Last edit at 10/03/2013 06:49AM by vic santoro.

Options: ReplyQuote

Written By
MySQL XML stored in View ?
October 03, 2013 06:40AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.