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