Re: Help requiring loading XML data into MySQL v5.0

[Harald Groven]

you should load each entity (in your case movie) in each row, not split by \n

LOAD DATA INFILE 'path.xml'
INTO TABLE `xyz`
FIELDS TERMINATED BY 'blablablabla' -- any nonexisting string
LINES TERMINATED BY '</movie>'
;

You can later create the field by

SELECT
EXTRACTVALUE(column1, '/movie/id') AS id,
EXTRACTVALUE(column1, '/movie/imdb_url') AS imdb_url,
EXTRACTVALUE(column1, '/movie/cast/actor[1]')
FROM xyz
;