XML data to database

sandy_1028 has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: XML data to database by Anonymous Monk on Nov 12, 2008 at 11:04 UTC
Isn't it about time you learned to format your posts properly, this is your 5th post? use DBI, see Tutorials: Database Programming	[reply]
Re: XML data to database by dHarry (Abbot) on Nov 12, 2008 at 12:39 UTC
Yeah your post is pretty unreadable. In general storing XML data in a relational dtabase is not straightforward. XML data is hierarchical which is different from the relational approach. Although most databases have XML import features/support nowadays. You’re data is very simple though, so something like: `INSERT INTO Person VALUES (department,name,sex,age)` [download]	[reply] [d/l]