Sayth Renshaw Create Schema and repeatable import of XML
Mar 09, 2015; 22:11
Sayth Renshaw
Create Schema and repeatable import of XML
Hi
Hoping someone can help me work some information or direction to a good resource for using XML with Mysql.
Specifically I have a complex XML file, I would like to create a schema in MYSQL based on it (I have XSD as well) and be able to upload new xml data into the database as it's released to me.
I cannot find a good way to achieve this, currently I am trying to use mysql for excel and map via excel into mysql. The data format is complex and a bit beyond scope of excel.
Are there good resources that how to work with XML?
Google searches don't show much but confusion and referral to expensive software such as XMLspy. If xml was supposed to be a universal format why is it so hard to work with.
Sayth.
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!