Dan - Or from my place, "It pays for me to read the docs - thoroughly". Oh! Docs! What are they? :-[ Todd Dan Greene wrote: The most guarenteed way to have a feature in a product pointed out is to make a public statement that it's not available :)keyboard in mouth, Dan Greene-----Original Message----- From: John Griffin [mailto:[EMAIL PROTECTED]] Sent: Monday, December 01, 2003 10:49 AM To: Dan Greene; Todd Cary; Jay Blanchard Cc: [EMAIL PROTECTED] Subject: RE: Export in XML Look at http://www.mysql.com/doc/en/mysql.html. The -X option may give you what you need. -----Original Message----- From: Dan Greene [mailto:[EMAIL PROTECTED]] Sent: Monday, December 01, 2003 9:57 AM To: Todd Cary; Jay Blanchard Cc: [EMAIL PROTECTED] Subject: RE: Export in XML I think that to answer Todd's question, no there is no inherent way in MySQL to export results as XML the way that sqlserver and oracle do. Another solution that comes to mind (if you're using java) is to write a simple class that converts a result set to an array of hashmaps (row in array is row of data, hashmap for column name - data value mapping), then send that to either castor (pre-java 1.4) or to the xml<-> object APIs (1.4 on).-----Original Message----- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: Monday, December 01, 2003 9:48 AM To: Jay Blanchard Cc: [EMAIL PROTECTED] Subject: Re: Export in XML Jay - I am not an expert with XML, however I use it with Delphi and Delphi's TClientDataset. In this usage, I use the builtin SaveTo and LoadFrom methods. Todd Jay Blanchard wrote:[snip] Is there a way to export/import MySQL tables in XML format? [/snip] Well Todd, it is a little more complex than this. How muchdo you knowabout XML?-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --
|
<<inline: NewLogo.gif>>