Sadrzaj XML fajla je ovakav:
<?xml version="1.0"?>
<Company_Info>
<Company_Name>ABC</Company_Name>
<Address_1>Street name and number</Address_1>
<City>City name</City>
<State>Your state</State>
<Country>USA</Country>
<Company_WebSite_URL>site</Company_WebSite_URL>
<Contact_Info>
<Author_First_Name>Mike</Author_First_Name>
<Author_Last_Name>Richardson</Author_Last_Name>
<Contact_First_Name>Software</Contact_First_Name>
<Contact_Last_Name>Calendar</Contact_Last_Name>
<Contact_Email>[email protected]</Contact_Email>
</Contact_Info>
</Company_Info>
<Software_Info>
<Program_Name>Software name</Program_Name>
<Program_Version>1.32</Program_Version>
<Program_Release_Month>7</Program_Release_Month>
<Program_Release_Day>22</Program_Release_Day>
<Program_Release_Year>2004</Program_Release_Year>
<Program_Cost_Dollars>10</Program_Cost_Dollars>
<Program_Type>Trial</Program_Type>
<Program_OS_Support>Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000</Program_OS_Support>
<Program_Language>English,Spanish</Program_Language>
<File_Info>
<Filename_Versioned>setup.exe</Filename_Versioned>
<File_Size_Bytes>2600001</File_Size_Bytes>
<File_Size_K>2601</File_Size_K>
<File_Size_MB>2.61</File_Size_MB>
</File_Info>
</Software_Info>
Kako mogu sada da importujem podatke iz XML fajla u MySql tabelu, ali tako da XML elementi budu smesteni u posebna polja? Npr. element izmedju <Program_Name> oznaka da bude u polju <Program_Name>, itd.