I am trying to import XML from this site http://data.gov.uk/dataset/car-parks into the phpmyadmin database, so I can use it in mashup with google maps.
I am new to this and don't know how to make XML in a database. First create database columns and import data?
There is a LOAD XML method in mysql , thanks to which you can import data from XML into your database.
Example:
LOAD XML LOCAL INFILE '/pathtofile/file.xml' INTO TABLE `tablename` (fieldl1, field2, ...);