What's the easiest way to put XML data into a MySQL database?

[Andy Forsberg]

What's the easiest way to put XML data into a MySQL database?

[asterix]

update mytable
 set myfield="<root/>"
 where mypk = $somevalue

Is that what you were looking for?

[Andy Forsberg]

If I understood what it meant, maybe.

[asterix]

It means use a normal update. Put the raw XML in the field...