Importing XML into phpMyAdmin using SQL



I'm stick with trying to import my XML data into phpMyAdmin using SQL but it's producing an empty output Any Idea?


SQL Query use geoweb; LOAD XML LOCAL INFILE 'E:/HTML/XAMPP/htdocs/Volunteer_Projects.xml' INTO TABLE projects(ProjectName,Postcode,Type,Longitude,Longitude);



EXAMPLE OF XML FILE
<record>
<ProjectName>Abersychan Pharmacy</ProjectName>
<Postcode>NP4 7BQ</Postcode>
<Type>Health</Type>
<Longitude>-3.05745263878</Longitude>
<Latitude>51.72295945</Latitude>
</record>


ERROR MESSAGE


use geoweb;# MySQL returned an empty result set (i.e. zero rows). LOAD XML LOCAL INFILE 'E:/HTML/XAMPP/htdocs/Volunteer_Projects.xml' INTO TABLE projects(ProjectName,Postcode,Type,Longitude,Longitude);# MySQL returned an empty result set (i.e. zero rows).


No comments:

Post a Comment