I'm running MySQL RC 5.1. I want to use the LOAD XML INFILE commands, but from what I can decipher, that's only available with Alpha version 6. I read references to it being added in RC 5.2.5, but I cannot locate that version anywhere.
I don't want to run an alpha database.
So, here's my dilemna...
1. Am I correct in that only v 6 supports the LOAD XML INFILE command? If not, what RC version can I upgrade to?
2. If I'm stuck not being able to support this import command, what's the best method of reading my xml file into my database? My XML will always look like: