import xml data to multiple tables in mysql

[Peng Yu]

Hi,

I have some xml data following the following DTD. It seems that it is
better to import the xml file into multiple table, for example, author
table, journal table. I read the mysql manual section on "load xml",
but I don't see how to load xml in multiple table and how to design
the schema automatically from DTD. Does anybody have some suggestions?

http://www.nlm.nih.gov/databases/dtd/nlmmedlinecitationset_110101.dtd



-- 
Regards,
Peng