Map column name to field name LOAD XML LOCAL INFILE

zeroflow

New Member
I have just exported a data table in XML format from phpPgAdmin. I want to load this file into my local mysql database. The table structure is the same for both databases.I know that mysql allows import of xml data using the example xml structure below:\[code\]<row><field name='column1'>value1</field>\[/code\]My problem is that phpPgAdmin has exported the data in this format:\[code\] <row> <column name='column1'>value1</column>\[/code\]Is there a way to map or SET the column name so I can import using LOAD XML LOCAL INFILE?
 
Back
Top