Importing .Xml file to MySql

[Bharath G]

Hello There,

I am using the following command to import data in .xml file to MySql database:

mysql> INSERT INTO network (NetworkId,State,NetworkName,DnSetup,DateCreation) VALUES(LOAD_FILE('C:\data_xml.xml'));

I am getting the following error:
ERROR 1136 (21S01): Column count doesn't match value count at row 1

Please let me know how to resolve this issue.