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?
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?
Jump to PostI've done this for an RSS feed. It queries the db, populates variables, and outputs everything as xml. Here is the link.
I've done this for an RSS feed. It queries the db, populates variables, and outputs everything as xml. Here is the link.
I wanted to know if it is posiible to write a MySql procedure to do the same??? Is that possible
Yes mysqldump will do this. Read more at http://articles.techrepublic.com.com/5100-10878_11-1044663.html
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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.