I want to write a MySql procedure which returns a formatted XML file i.e. 'OUT BLOB'.
Has anyone come across such a procedure or is it better to make a Java etc... code do the same?
rich_m 0 Newbie Poster
buddylee17 216 Practically a Master Poster
I've done this for an RSS feed. It queries the db, populates variables, and outputs everything as xml. Here is the link.
rich_m 0 Newbie Poster
I wanted to know if it is posiible to write a MySql procedure to do the same??? Is that possible
buddylee17 216 Practically a Master Poster
Yes mysqldump will do this. Read more at http://articles.techrepublic.com.com/5100-10878_11-1044663.html
rich_m 0 Newbie Poster
Yep thanks again for the above information, what i wanted to know was if i could get a MySql stored procedure to do the same!!!! This way i can customize the procedure to give me some data based on the data in the database, rather than giving me all the data as an XML snap shot.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.