Re: XML to RDB

2013-11-25 Thread Johan De Meersman
approaches at the same time. - Original Message - From: Larry Martell larry.mart...@gmail.com To: Steven Siebert smsi...@gmail.com Cc: mysql mailing list mysql@lists.mysql.com Sent: Friday, 22 November, 2013 3:17:44 PM Subject: Re: XML to RDB Yes, I will need to query the data, and yes

Re: XML to RDB

2013-11-25 Thread Steven Siebert
: Larry Martell larry.mart...@gmail.com To: Steven Siebert smsi...@gmail.com Cc: mysql mailing list mysql@lists.mysql.com Sent: Friday, 22 November, 2013 3:17:44 PM Subject: Re: XML to RDB Yes, I will need to query the data, and yes, it's app specific to the data. The parent-node

Re: XML to RDB

2013-11-25 Thread Larry Martell
- From: Larry Martell larry.mart...@gmail.com To: Steven Siebert smsi...@gmail.com Cc: mysql mailing list mysql@lists.mysql.com Sent: Friday, 22 November, 2013 3:17:44 PM Subject: Re: XML to RDB Yes, I will need to query the data, and yes, it's app specific to the data. The parent-node

Re: XML to RDB

2013-11-25 Thread Larry Martell
PM Subject: Re: XML to RDB Yes, I will need to query the data, and yes, it's app specific to the data. The parent-node structure will meet my needs if I can figure out how to preserver the unbound multi level nodes. There will be a higher level table, which will have the file name

XML to RDB

2013-11-22 Thread Larry Martell
I have a need to store data that comes in an XML file in MySQL. I don't want to store the entire file as a CBLOB, and it doesn't lend itself to loading with Load XML. I am looking for tools that will help me create the schema and parse and load the data. I have googled for this and I've found many

Re: XML to RDB

2013-11-22 Thread Steven Siebert
Hi Larry, I'm trying to figure out what your wanting to do with the data once its in mysql? At first it seemed you didn't want to put it in as a lob because you might want to query on the data in different ways (kind of an assumption on my part, but a common reason to do this). Then, you

Re: XML to RDB

2013-11-22 Thread Larry Martell
On Fri, Nov 22, 2013 at 8:05 AM, Steven Siebert smsi...@gmail.com wrote: Hi Larry, I'm trying to figure out what your wanting to do with the data once its in mysql? At first it seemed you didn't want to put it in as a lob because you might want to query on the data in different ways (kind