Reading xml with libxml2 in C

I have the following XML File:

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<category>
    <data>
        <ca0>100</ca0>
        <ca1>Spielfilm</ca1>
        <ca2>Spielfilm</ca2>
    </data>
    <data>
        <ca0>200</ca0>
        <ca1>Serie</ca1>
        <ca2>Serie</ca2>
    </data>
</category>

I am developing a C program, which should read this xml file and transfer it into a mysql database. I have looked at several examples but I didn't success.

How can I read the xml with libxml2 and transfer it into a mysql Database?

Thank you!