Solved

Convert XML into MySql table(s)

Posted on 2013-01-26
3
326 Views
Last Modified: 2013-02-11
I have a xml-file. How do I create the right mysql table(s) for it so I can import it? Is there an automated solution?

Thanks!
0
Comment
Question by:dirkacm
  • 2
3 Comments
 
LVL 8

Accepted Solution

by:
ee_reach earned 100 total points
ID: 38823182
0
 

Author Comment

by:dirkacm
ID: 38875048
Thanks for the proposed solution.
This solution is good for straight forward one level xml, not complicated stuff.

Thanks,
Best regards,

Dirk
0
 

Author Closing Comment

by:dirkacm
ID: 38875051
Please see my comment in the post.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question